Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Monte Kottman,
I was working in a large 100+ SQL server web farm with many environments and clusters, and when a server restarted, I had no way of knowing where it was.
I wrote this script and created a job that would be scheduled to run at start up. It would not only notify me via email that it started, but it would place the information in the application event log so that Microsoft System Center Operations Manager (SCOM) could see it.
String or binary data would be truncated.
String or binary data would be truncated!!!
For this Friday, Andy Warren asks if you would pay to change your wardrobe for work.
Red Gate survey asks would you take cash or trip of a lifetime?