SQL SERVER – Script to Find SQL Server on Network | Journey to SQL Authority with Pinal Dave

I manage lots of SQL Servers. Many times I forget how many server I have and what are their names. New servers are added frequently and old servers are replaced with powerful servers. I run following script to check if server is properly set up and announcing itself. This script requires execute permissions on XP_CMDShell.… Continue Reading...

Source: SQL SERVER – Script to Find SQL Server on Network | Journey to SQL Authority with Pinal Dave