Is this in your server or your client?

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

2) at http://www.microsoft.com/sql/downloads/2000/sp3.asp I find it kind of confusing as to what exactly is the sp3 download. if you click the link to direct to next page for download there...

The book Inside SQL Server 2000 by Kalen Delaney.

http://www.insidesqlserver.com/index.html

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Using bcp is also an option. Probably faster than DTS. However, it's not as intuitive and you'll want to test your scripts to backup and restore before relying on them.

K....

SP3 was released prior to the Slammer worm, so the two aren't related. Now, whether or not they rushed the MSDE MSMs could be another story.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to...

This is a good idea, too. We extracted to a central location and then copy the files down. I know, more load on the network, but...

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to...

Does each thread create its own copy of temp table ?

It depends on how you are creating the temp table. If you are doing #TempTable (one bang), then one temp...

One other solution is to create personal folders and having mail delivery go to there. I'll try and get Void to post what he did on that here. This ensures...

Sadist! Actually, I was planning on doing that.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Haven't tried to diagrams but my hunch is you can't. If you have a modeling tool other than Enterprise Manager quite possibly you can.

You can't do relationships like foreign key...

Use the 3 part naming convention:

<Database>.<Owner>.<Object>

For instance:

Northwind.dbo.Customers

The login executing the query will have to have a mapped user in the database you are referencing and permission to access the object.

K....

Yup, NPeeters has it correct. The way to check service pack is the 8.00.XXX number. The "Service Pack 2" is for the OS.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to...

We haven't had any issues with it on our production systems.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

I've never really tested xp_startmail and xp_stopmail enough to trust it. Probably would work, though.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

You can either:

1) deny execute on it when Exchange is down and grant execute on it when Exchange is back (doesn't affect sysadmin role users)

or

2) drop xp_sendmail when Exchange...