SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Automation of sql server management studio settings


Automation of sql server management studio settings

Author
Message
IT researcher
 IT researcher
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1572 Visits: 1798
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
Andrew G
Andrew G
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3953 Visits: 2279
Tools - Import and Export Settings - export your setup to file, import on the other PC's
IT researcher
 IT researcher
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1572 Visits: 1798
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?
Andrew G
Andrew G
Hall of Fame
Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)Hall of Fame (4K reputation)

Group: General Forum Members
Points: 3953 Visits: 2279
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.
IT researcher
 IT researcher
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1572 Visits: 1798
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
IT researcher
 IT researcher
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1572 Visits: 1798
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?
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search