This script provides a quick and easy way to get some useful connection information from your SQL Server instances. It is very helpful if you have a SQL cluster running multiple instances and want to quickly find out what node the instance is running on or the IP address or port for each of your instances.
SQL Start up Script
This is a script that I run when SQL starts to notify me via email that a server has restarted as well as the location of the server.
2012-09-25 (first published: 2012-08-29)
1,845 reads