Tuesday, September 8, 2009

SQL Tips

SQL Tips

1. Do not use the stored procedure within the DTS jobs.
2. When the server crashed or harddisk crashes, if you do not have msdb backed up the DTS Jobs are lost.
3. Please make sure your master and msdb database are backed up.
4. Also have the procedures written as stored procedures and call them in DTS.

1 comment:

  1. despite the presence of other data recovery methods, I recommend another service of download dbf fille fix

    ReplyDelete