Post reply

How to add locations to Open File dialog box in SSMS

  • April 20, 2010 at 1:13 pm

    #231879

    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.

  • April 20, 2010 at 3:08 pm

    #1154969

    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]

  • May 8, 2010 at 8:05 am

    #1164565

    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.

  • July 23, 2010 at 7:13 am

    #1197486

    This was GREAT! Thank you.

  • December 23, 2010 at 10:13 am

    #1266009

    Doesn't work for 2008. Any ideas?

    Thanks

  • April 26, 2011 at 11:51 am

    #1316080

    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.

  • April 26, 2011 at 12:52 pm

    #1316124

    working!.. thank you!

  • August 29, 2011 at 8:26 am

    #1374501

    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]...

  • October 13, 2011 at 12:02 pm

    #1394276

    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.

  • February 17, 2014 at 7:08 am

    #1689500

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

  • November 19, 2014 at 3:59 am

    #1759472

    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 😀

  • June 10, 2015 at 6:52 am

    #1804313

    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