Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Automation of sql server management studio settings Expand / Collapse
Author
Message
Posted Tuesday, February 5, 2013 9:40 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 20, 2014 10:15 PM
Points: 265, Visits: 1,713
Hi,
We are using sql server management studio 2008. After installing management studio to each computer if we want to change settings,we have to do it manually. It is little inconvenience.Is there any way to automate settings or is there any configuration file that we can copy after each new installation? please help
Thank you
Post #1416229
Posted Tuesday, February 5, 2013 11:59 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 12:34 AM
Points: 1,143, Visits: 1,585
Tools - Import and Export Settings - export your setup to file, import on the other PC's
Post #1416265
Posted Wednesday, February 6, 2013 12:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 20, 2014 10:15 PM
Points: 265, Visits: 1,713
Thanks for reply

I think "Import and Export Settings" not present in management studio 2008 And even in management studio 2012 i doubt all settings are importing. I have tried to import new settings but after opening of management studio old settings seems to be retaining
And where will be settings file located?
Post #1416286
Posted Wednesday, February 6, 2013 12:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 12:34 AM
Points: 1,143, Visits: 1,585
Oh sorry, I didn't notice this was in the 2008 area of the forum, it works for 2012.

Ok, you could try exporting the registry key:
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell

Then importing that on the other machines. You can see all the settings that are configured in there.
Post #1416292
Posted Wednesday, February 6, 2013 2:52 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 20, 2014 10:15 PM
Points: 265, Visits: 1,713
Thanks for reply
I don't think importing KEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell working. Don't know about other settings but it certainly not working for edit top n rows and select top n rows settings
Post #1416349
Posted Sunday, February 10, 2013 10:44 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 20, 2014 10:15 PM
Points: 265, Visits: 1,713
Importing KEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell registry changes only some settings like tools->option->designers.Other settings like tools->option->sql server object explorer not changing.. where is the registry for those changes?
Thank you

We are using sql server management studio 2008 express edition. Is that makes any difference?
Post #1418209
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse