I’ve previously blog, about programmatically registering SQL instances in SQL Server Management Studio (SSMS) and on Dynamically discovering SQL instances through SMS/SCCM. This post combines the two techniques showing how to register any missing registrations from your SSMS 2008 or simply register all SQL instances in a new group. Copy the following code to a file (for example…
Tag Archive: SSMS
Registering SQL Servers in 2000 EM, 2005 SSMS, and 2008 SSMS
I support hundreds of SQL Servers and rather than manually registering SQL instances through the GUI I prefer to register SQL instances programmatically for each version of SQL Server. This is particuarlly true with SQL Server 2000 which offers no built-in way to import/export server registrations. SQL Server 2005/2008 introduced the capability to import/export an XML .regsrvr file, so I find…
