December 19, 2007 at 12:02 pm
Due to some recent changes at my company I need to access SQL Server 2005 Management Studio via remote desktop using one of several different servers. That is, if one is overly occupied with users, then I'll access the next server... and so on. The same tasks are performed from each server.
Since from each remote server I need to access databases from multiple registered servers from the Management Studio interface, is there a way in which I export all of my settings used in Management Studio from one server and then import them to the other servers where I would be performing the same tasks?
Otherwise, it may be as simple as copying my personal profile settings from the Documents and Settings folder. But I'm curious if there is an approach that is limited to just the SQL Server 2005 Management Studio settings.
Thanks,
Grant
December 19, 2007 at 1:05 pm
There are bits & pieces scattered around the place. The stuff I have found is:
Registry: HKCU\Software\Microsoft\Microsoft SQL Server
C:\Documents and Settings\[username]\Application Data\Microsoft\Microsoft SQL Server
C:\Documents and Settings\[username]\Local Settings\Application Data\Microsoft\Microsoft SQL Server
C:\Documents and Settings\[username]\My Documents\SQL Server Management Studio
and possibly:
C:\Documents and Settings\[username]\Application Data\Microsoft\Visual Studio
C:\Documents and Settings\[username]\Local Settings\Application Data\Microsoft\Visual Studio
Not sure how many of these are required to capture all settings. Subject of experimentation I guess.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
December 19, 2007 at 1:15 pm
Thanks, Scott.
I'll give your suggestions a try. I miss the good old days when I had local access to SQL server.
Grant
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply