Have you check "osql" utility which allows running SQL scripts against Sql 2000?

http://technet.microsoft.com/en-us/library/aa213088(SQL.80).aspx

Hi Jack,

I think this is pretty brave advice to tell to replace clustered index on the table with nonclustered one. What about other queries, maybe it’s being used successfully somewhere...

Hi,

What about recording trace (http://support.microsoft.com/kb/283790/) with SP:Completed or RPC:Completed events. Later importing trace files into your dev database and quering the result set for long running querier (...

First of all, before posting check if XML is valid (XML Notepad or even VS editor will do the check).

I believe that you've got number of entries in 'docs' table,...

File extension for 'Save Result as ' dump seems to be no longer configurable, as even registry entry storing the configuration value has been removed.

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQL Query Analyzer

ExtnSave:=.rpt

To...

Have you reviewed checklist provided in 'An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step' article (http://support.microsoft.com/kb/918760)?

There is...