SQL Server Management Studio Projects Path

The projects path for SQL Server Management Studio cannot be changed easily. It tries to save your scripts and other documents in a projects directory under your “My Documents” directory. If you don’t want SQL files stored in, say,

%USERPROFILE%\My Documents\SQL Server Management Studio Express\Projects\

(if you use SQL Server Express) you have to dig deeper to change it. I have found myself often annoyed at management studio’s insistence on putting files there. I had to change 7 keynames (including, for example, DefaultOpenSolutionLocation) Registry Keys for SSMSE files at the following location:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM

to my preferred path (I used an absolute path in this example):

C:\my-svn

for my Subversion Working directory. Then everything was cool.

About these ads

3 thoughts on “SQL Server Management Studio Projects Path

  1. Pingback: links for 2009-03-13 - Craig's Blog

  2. HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\ProjectLocationEntries

    For Microsoft SQL Server Management Studio 9.00.1399.00

    • Man… they keep changing it:

      On Windows 7 and for Microsoft SQL Server Management Studio 10.50.2500.0
      the key is:
      DefaultFileOpenLocation
      in
      HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s