I've installed sql2ksp3 with success, but DTS gave me headaches. All worked but those connecting to DB2 UDB V7.2 (rtm version). Contacted pss and it took a couple of days...

that goes also for those using a comma as decimal point (user setting!).

Must have been for Valintines day :))

I've got a sp3-dts problem in a transfert from db2os390 to sqlserver(local). Still working on it with MS. I'll keep you informed.

Thanks. I'll definitely check with MS.

fyi check http://support.microsoft.com/default.aspx?scid=KB;EN-US;814113

I too have an xp_sendmail problem. This occurs on a w2k-sp2 clustered server (i know mail is not supported on a cluster, but anyway) Every once in a while it...

take a look at : Microsoft Knowledge Base Article - 814064 BUG: SQLBrowseConnect May Cause an Access Violation in the Client Application.

try this :

Setup.exe /upgradesp SQLRUN INSTANCENAME=MSSQLSERVER SECURITYMODE=Sql UPGRADEUSER=sa UPGRADEPWD=<sa pwd>

what if that original node is gone ?

Great article. Especialy the conclusion, wich IMO should be put en a red colour and an extra bold font.

remember you can only shrink your logfile at "the end". If that last section is in use, you cannot shrink. The "forced" shrinks only fillup the last section during a...

Use dbcc traceon(1204; 3605; -1) to have sqlserver log deadlock-situations in the sqlserver-logs. This gives good info.

Where the spids in as rollback-state ? Then you cannot kill them. I've noticed this in relation with some non-IT-developed access-applications. After these applications where banned to use the production...

Maybe I'm looking at a small scale, but any chance DTS could help out ?

When scripting remember to script the user/role-autorities as well !

As for the warm feeling : Enjoy it as much as possible!