How about..

declare @thisquarter varchar(10)

declare @sql nvarchar(4000)

declare @mycolumnheader varchar(50)

set

@thisquarter = '2006SU'

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_1d7y.asp

Probably can just capture data from master.dbo.sysperfinfo

You must run the instcat.sql script on the SQL 2000 machine.  This script is part of the SQL 2000 SP4 installation (even though it doesn't get executed as part of...

Did you forget to update the sa password in the agent properties?   Note:  if you change this password via the Management Studio GUI for a SQL 2000 agent service, it...

Have you registered the SPN for the SQL Server service account?

In 2000 SMTP mail does not require outlook.

exec @rc = master.dbo.xp_smtp_sendmail

@from

= @EmailFromAddress

Awesome article.  You said what we were all thinking.  "Who actually uses this crap?"

I say, unless you are using SQL 2005, don't switch.  The new tools got a TON of bugs.  What happened to the "script database objects" feature?  I gotta do it...

DBCC INDEXDEFRAG

Idera and Litespeed both do.  RedGate not for a month or so.

We've been getting the 17883 (which have many causes) as well.  I will share all the info I know. 

http://support.microsoft.com/kb/892940

http://support.microsoft.com/kb/890730

http://support.microsoft.com/kb/810885

http://support.microsoft.com/kb/909380/en-us?spid=2852

http://support.microsoft.com/Default.aspx?kbid=889114

http://support.microsoft.com/kb/330307

http://support.microsoft.com/kb/825197

select

u.name as 'Role_Or_User',

o

.name as