How to add locations to Open File dialog box in SSMS

  • Hey all,

    I have a small issue that's been bothering me. When I go to open a file in SSMS, the Open File dialog box appears. In the left side of that box, there is a panel containing shortcuts to various locations: Desktop, My Projects, and My Computer. I would like to add some shortcuts to folder that I use in this area, but I haven't been able to figure out how. Does anyone know how to do this? I would appreciate any help that anyone can give. Thanks.

  • Here's where you'd find that for SSMS with 2005.

    [font="Courier New"]\HKCU\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\Open Find\Places\UserDefinedPlaces[/font]

    Add subkeys Place0,Place1,Place(n)

    Under each subkey add two REG_SZ values

    [font="Courier New"]Name = "Shortcut Name"

    Path = "Folder location"[/font]

  • This seemed to work. Thanks!

    Just to be clear, what I did was create a key called Place1 in the folder indicated. I created two string values under that key, one with Name = "Name" and Data = "[Shortcut Name]" and the other with Name = "Path" and Data = "[Path of Folder]".

    I don't know if makes a difference, but I'm running Windows Vista.

    Thanks again, this method seems pretty handy.

  • This was GREAT! Thank you.

  • Doesn't work for 2008. Any ideas?

    Thanks

  • irina_bit (12/23/2010)


    Doesn't work for 2008. Any ideas?

    Thanks

    I'm running SQL 2008 R2 now, and this method still works for me. Simply look for the registry path \HKCU\Software\Microsoft\Microsoft SQL Server\10... instead of 9...

    Hope that helps.

  • working!.. thank you!

  • Update for Windows 7 x64 OS:

    Use HKEY_USER instead of HKEY_CURRENT_USER. You'll need to know your current SID (Security ID). This you'll find by looking at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList. Hint, the SID for your user will have a ProfileImagePath corresponding to C:\Users\[your login]...

  • Eric Stimpson (8/29/2011)


    Update for Windows 7 x64 OS:

    Use HKEY_USER instead of HKEY_CURRENT_USER. You'll need to know your current SID (Security ID). This you'll find by looking at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList. Hint, the SID for your user will have a ProfileImagePath corresponding to C:\Users\[your login]...

    I'm using Win. 7 x64, and I am able to modify the places using the original method specified. I'm curious to know if this method is for adding paths for users other than the user currently logged in.

  • This is an old post, but just wanted to add a "Thanks!" This worked great for me!

  • Sorry that i am also adding to this old post but i am using windows 7 on and i needed to uses the HKEY_Users method to get it working, I am using SQL express 2008 r2.

    Never the less thanks 😀

  • Will this be applicable for sql server 2014? ... If not is there a different way to handle this without changing values in registry

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply