Following standard ETL practices, load your data into a staging table the use multiple ExecuteSQL tasks to execute your stored procedures in required order. This will allow you to process...

Also, instead of using @@IDENTITY, you should use SCOPE_IDENTITY().

Check Books Online for descriptions of each.

Two other options you can try,

1) Generate a script of the jobs. In the resulting script, make sure the line that executes 'sp_add_jobserver' has '(local)' as the target server. Then run...

Second vote for XPSMTP. Currently all emails form our 20 odd SQL Servers (notifications, reports, etc...) is sent using XPSMTP. Have had no issues since setting it up over two...

Good article, always handy to see alternative methods.

I built a C# console app that renders the reports via the webservice. Once I got my head around the .Net stuff is...

I'm betting xp_fileexist doesn't understand wildcards. It's probably looking for the existence of a fully specified file. How about trying the DIR method again

Sorry guys ... can't read any of that ... I tend to tune out when there is a lot of bolding and uppercase typing.

Ahhh ... "weak encryption scheme" ... that's the phrase I was searching for while typing up my post

But what about if the server you're restoring to does not know about the backup file as per the original posting?

I think my DIR proposal provides much more flexibility. You...

For the Active Directory information a quick search of this site found these,

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=13037

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=102117

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=153994

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=188480

Doubtless you would find more if you searched via Google.

Don't forget SQL Agent job history, DTS Package logging, etc...

Monthly service level reports look a bit wonky when there are gaps due to lost data

The use of Windows or Mixed security would depend on the equirements for your environment.

If you have a seperate web server that accesses a database on a stand-alone SQL Server then...

Be aware that if you use UDL files to store the username and password they will be in plain text and available for anyone that has read access to the...