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.

---

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

For 7.0 and above <dbname>..syspermissions.

---

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

A. For all 32-bit clients the following are used. For 16-bit Windows clients WIN.INI is used...

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

---

A. With SQL 6.5 and below use the "set rowcount <n>" option...

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))

---

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 :...

A. Do a select * from sysprocesses and identify the spid in question. Then do a "KILL <spidno>"...

A. A choice :...