Why am I getting a message 'The Enterprise Edition server component cannot be installed on Windows NT Server using this CD.' installing SQL 7?
Jul 27, 1999

A. You are trying to install SQL 7 Enterprise Edition on an ordinary copy of NT Server. You can only install SQL 7 EE on NT EE.

This may be due to you getting a mis-labelled set of MSDN disks.


Where does SQL server store the permissions on tables?
Jul 27, 1999

A. For SQL 6.5 and below this is held in <dbname>..sysprotects. 

For 7.0 and above <dbname>..syspermissions.


Where can I get examples of XP code for SQL Server?
Jul 27, 1999
A. For SQL 6.5 download the PTK from http://support.microsoft.com/download/support/mslfiles/PTK_I386.EXE  For SQL 7 look on the CD under \devtools
What registry entries does SQL Server's client use?
Jul 27, 1999
A. For all 32-bit clients the following are used. For 16-bit Windows clients WIN.INI is used...
What is the equivalent of an Oracle synonym in SQL Server?
Jul 27, 1999

A. Create a view.
create view titlessynonym as select * from titles


Learn To Restrict the Number of Rows Returned To the Query In SQL Server
Jul 27, 1999
A. With SQL 6.5 and below use the "set rowcount <n>" option...
Is there a DATE function for SQL Server? I don't want to hold the time.
Jul 27, 1999

A. No, just datetime, but you can strip out the time (reset it to 00:00) using :-

select convert(datetime,convert(char(10),getdate(),101))


I've put tempdb in ram and now I can't restart my SQL Server.
Jul 27, 1999
A. This is because the memory allocated by SQL Server does NOT include tempdb in ram. There must be enough memory for SQL, tempdb AND NT otherwise SQL will fail to start. To recover from this :...
How can I stop a SQL Server process?
Jul 27, 1999
A. Do a select * from sysprocesses and identify the spid in question. Then do a "KILL <spidno>"...
How can I run a DTS package from within SQL Server - e.g. a stored-procedure? - 28 Jul 1999
Jul 27, 1999
A. A choice :...
  • Load More
  • first
  • previous
  • …
  • 1037
  • 1038
  • 1039
  • 1040
  • 1041
  • 1042
  • 1043
  • 1044
  • 1045
  • …
  • next
  • last
Load More