Hi all,
I had a good news about the Microsoft SQL Server 2008 February CTP which may
delight some of the sql developers and database administrators like me.
I had many times re-registered the SQL Servers in my network that I connect and
work on because I installed newer versions of MS Enterprise Manager or SSMS.
I believe, you have experienced the problem that annoys sql server developers or
sql server administrators that has SSMS (SQL Server Management Studio for SQL
Server 2005 and SQL Server 2008) or its previous version or name SQL Server
Enterprise Manager (for Microsoft SQL Server 2000) installed on their computer
to connect to database servers from remote and work using the query editors and
the database management tools coming with the default user interface.
When I first run the SSMS (SQL Server Management Studio) that I have installed
as the client tools with SQL Server 2008 CTP6 or February CTP, I had been
promted whether I want to register the servers that are registered in the
previous SSMS application.
Microsoft SQL Server Management Studio
There are SQL Server 2005 Management Studio registered servers on this system.
Do you want to add them into Microsoft SQL Server Management Studio? Adding the
server registration information has no effect on the servers themselves.
Of course I accepted happily this wonderful suggestion.
By the way, for Microsoft SQL Server 2008 SQL Server Management Studio, the list
of registered servers are kept in %UserProfile%\Application
Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\RegSrvr.xml RegSrvr XML
file.
The SQL Server Management Studio (SSMS) for MS SQL Server 2005 stores the
registered servers list information in folder %UserProfile%\Application
Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\RegSrvr.xml Regsrvr.xml
XML file