Scan an IP Range for SQL Server Instances

There are other tools such as SQLPing (http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26) that can be used to scan an IP address range for SQL Server instances. However if you need to also accurately determine the build of each SQL Server instances including MSDE instances to ensure that the latest service pack has been applied then the SQL Server 2000 SQL Scan Tool is a the tool for you. Although a little slow scanning a large range of addresses it generates a CSV file with the IP Address and the Product Level and OS information along with additional build information.  SQL Server 2000 SQL Scan Tool was originally released by Microsoft to assist with determining machines that were vulnerable to the ‘Slammer’ worm and can be downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyID=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en.