CDONTS will let you point at an SMTP server. If your admins want you to use SMTP, I assume they already have one. It should be in the critical path...

Been there, done that. You can fix it by going into the registry, but it's not a welcome experience. We had contractors set up a clustered sql server and then...

This is the same break point another user is getting on a Win2K SP2 w/ MDAC 2.7 on the system. I've got his dump and it's pretty much identical. Me...

This is true on a stand alone system but just in case someone reads this thread with a clustered server... If you are changing the IP address on a clustered...

You can build into the process using a WHILE loop or something of that nature checking for an entry on a table. If it finds that entry, the process stops...

You can use a GRANT EXECUTE, so far as I am aware. However, you need to have the proxy account setup. Any users trying to execute xp_cmdshell who are not...

If you do have subnets, then ACLs can be used on the networking equipment to restrict.

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

CDO does use COM.

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

Is there a reason the column order is important?

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

Completely agree with Clive. If you assign against an NT group and another NT group needs the same rights, you're redoing all the work. It's the same concept behind putting...

Keep in mind that the tenets behind the "theoretical underpinnings" of relational database systems say the columns and rows can be in any order.... as a result, if specific order...

They mean SMTP mail where you are connecting to a separate SMTP server or SMTP mail where you need to install IIS and the SMTP portion on the same server...

What happens when you run the DTS Package manually after such a job failure?

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

Check out eEye's Retina tool as well. There's a free download for class C subnet checks to test if you've got sa with no password.

A great site for information...

BORK = Back Office Resource Kit. The SQL Load Tool came on a CD with BORK 4.5. Database Hammer is a VB app that can be customized with the...