Configuring SQL Server Data Transformation Services for Mail - Video Series Video Category: Working with the Common Tasks in DTS Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2000 This series focuses on setting up SQL Server and DTS to use the Send Mail Task - a not-so-trivial task in itself.

Videos in this Series:

Title Skill Length Download Part 1 - An Overview of the Send Mail Task and How it Works in DTS   200 9 mins. Download Part 2 - Configure SQL Server to Use the Send Mail Task and Correctly Execute Sc...   200 14 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

SQL Server 2000 Resource Kit - More Helpful Tools: SQL DMO has many nice examples of using DMO to script your SQL Server administration Security Tip: Protect your backups! Many DBAs often do not realize that anyone that can get to your SQL Server database backups can also restore those backups on their own SQL Server. One additional layer of file-based security that you can add in is to put a password on your backup file. This can only be done with Transact-SQL but it cannot be bypassed during the restore Did you know that the fixed server role "Database Creators (dbcreator)" can drop any database on the server? Ouch!