It'll always be 8.00.194 SQL Server 2000

This was the RTM release

See this for prety much version numbers...

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37

If the table is a heap (no indexes) then the new column will be stored separately from the rest of the row, resulting in extra IO.

If it has clustered...

2.  With Outlook 2k2 OR Windows Server 2k3 you again have to have Outlook open to send mail.  Friend of mine ran across this problem.  Windows 2K and Outlook 2K...

Thanks.

I might have considered xp_cmdshell but maybe because I wanted to use a function rather than stored proc. I can't remember for sure now.

xp_cmdshell is simple, maybe better, solution though...

A select statement will generate an error if the linked server isn't there, but because it'll most likely be classed as a distributed transaction then SET XACT_ABORT will be ON,...

In T-SQL without "NOT IN"

SELECT TOP 1 *

  FROM (SELECT TOP 2 * FROM Table ORDER BY MinMaxCol DESC) DR

  ORDER BY MinMaxCol ASC

What about restarting the SQL services? Rebooting the server?

Installing SQL?

Changing some server properties writes to the...

Without being too blunt, setspn doesn't stop the error.

All our servers have SPNs registered (and delegation etc) as we use lots of linked servers and pass-through authentication and we still...

If the SQL Service account is not LOCALSYSTEM or a domain admin (or similar) then this error will happen and the SQL acount can't register an SPN.

SPNs (Service Principal Names)...

It's in the SQL client tools folder.

Select "Named Pipes" in the drop down, click "Change" and that should be it.

The 16 bit and 32 bit client tools are completely independent and don't care about each other.

16 bit clients use these files in \Windows\System (not System32): DBMSSOC3.DLL, DBNMP3.DLL, DBMSSPX3.DLL, MSDBLIB3.DLL,...

What if they just Terminal Services onto the SQL server and run the tools anyway? Because they are domain or enterprise admins, they can do whatever they want - it...

From BOL "CREATE TABLE"

...

If CLUSTERED or NONCLUSTERED is not specified for a PRIMARY KEY constraint, CLUSTERED is used if there are no clustered indexes specified for UNIQUE constraints.

...

If CLUSTERED or...

I've seen big space usage drops when just going through tables and changiong "unique" indexes into clustered ones because of the removal of a leaf level

Creating a "unique" index in...

sp_send_cdosysmail is not a standard SQL server object so it may be possible to have it in a user database. It depends what it calls in turn.

I take it the server...