Change Ssms2008 default setting on installation

Posted by CziX on Stack Overflow See other posts from Stack Overflow or by CziX
Published on 2010-03-31T07:08:41Z Indexed on 2010/03/31 7:13 UTC
Read the original article Hit count: 519

Filed under:

ssms2008

|

settings

Hey, I am currently developing a vbs script, which installs SQL server 2008 + SP1. After the install I want to change the default settings in the Ssms, such as "Prevent saving changes that require table recreation" and such on.

I can't figure out, where Ssms hides its settings. Currently I am looking at 1) My Documents\SQL Server Management Studio\ 2) HKCU\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\Profile

But whenever I change a "setting" in the vssettings-file in 1), Ssms thinks it is first time it runs, and overwrite.

How can I change the Ssms setting manual, without doing it from the Ssms itself?

© Stack Overflow or respective owner

Related posts about ssms2008

Change Ssms2008 default setting on installation

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, I am currently developing a vbs script, which installs SQL server 2008 + SP1. After the install I want to change the default settings in the Ssms, such as "Prevent saving changes that require table recreation" and such on. I can't figure out, where Ssms hides its settings. Currently I am looking… >>> More
Activity monitor is unable to execute queries against server

as seen on Server Fault - Search for 'Server Fault'
SQL Server Activity Monitor fails with an error dialog: TITLE: Microsoft SQL Server Management Studio The Activity Monitor is unable to execute queries against server [SERVER]. Activity Monitor for this instance will be placed into a paused state. Use the context menu in the overview… >>> More
Viewing a large field in a query in SQL management studio with ZOOM?

as seen on Server Fault - Search for 'Server Fault'
Hi there, Can anyone help? I am using SQL management studio (sql server 2008) to run queries and some of the fields that come back are varchar(max) for example and it has a lot of information - Is there a zoom feature to open the window and show me the contents with vertical and horizontal scrollbars… >>> More
Can't connect to MS SQL Server database using SSMS

as seen on Server Fault - Search for 'Server Fault'
I have a database on line with Godaddy (who uses SQL Server 2005). They provide basic management tools, but tell you that for more advanced tools you can connect directly using SSMS. I followed their instructions to ensure my online database will accept remote connections, and can apparently log in… >>> More
"Classic" activity monitor in SQL Server Management Studio 2008?

as seen on Server Fault - Search for 'Server Fault'
Right now I'm using SQL Server Management Studio 2005 to manage all my SQL servers (2000, 2005, 2008). I'd love to be able to take advantage of all the cool new features in SSMS 2008, the only thing holding me back is the new DMV-based activity monitor: We are still 40% SQL 2000, which doesn't have… >>> More

Related posts about settings

C# Enterprise Block Application Settings and Settings.Settings designer

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working with v4 of the Enterprise Application block and I am trying to learn how to access the Application Settings that I have added using the Enterprise Library Configuration tool. It's as if the code does not recognize the settings even though I can see them in the app.config. I DO have… >>> More
C# Problem with Settings.Reload() and Settings.Save() Settings not loading

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a strange issue that I can't figure out. I have a custom settings class that inherits ApplicationSettingsBase. It has a user scoped settings as shown below. /// <summary> /// The Last Active Account /// </summary> [UserScopedSettingAttribute()] public AccountKeyClass… >>> More
Problem with .NET Settings.Reload() and Settings.Save() Settings not loading

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a strange issue that I can't figure out. I have a custom settings class that inherits ApplicationSettingsBase. It has a user scoped settings as shown below. /// <summary> /// The Last Active Account /// </summary> [UserScopedSettingAttribute()] public AccountKeyClass… >>> More
Creating settings like the Mail settings in the Settings app

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to create some settings much like the Mail settings within the Settings app. These allow you to add mail accounts to the end of the table First screen --------------- + | add account | --------------- When they click on the cell, they are pushed onto a new screen where they fill in a… >>> More
Creating settings like the Mail settings in the Settings app

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to create some settings much like the Mail settings within the Settings app. These allow you to add mail accounts to the end of the table First screen --------------- + | add account | --------------- When they click on the cell, they are pushed onto a new screen where they fill in a… >>> More