How to add locations to Open File dialog box in SSMS

  • SQLUserC

    SSCrazy

    Points: 2345

    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.

  • Todd Engen

    SSCrazy Eights

    Points: 9869

    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]

  • SQLUserC

    SSCrazy

    Points: 2345

    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.

  • SETH DEBRIERE

    SSC Enthusiast

    Points: 125

    This was GREAT! Thank you.

  • irina_bit

    SSC Enthusiast

    Points: 168

    Doesn't work for 2008. Any ideas?

    Thanks

  • SQLUserC

    SSCrazy

    Points: 2345

    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.

  • irina_bit

    SSC Enthusiast

    Points: 168

    working!.. thank you!

  • Eric Stimpson

    SSChasing Mays

    Points: 649

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

  • SQLUserC

    SSCrazy

    Points: 2345

    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.

  • treusch

    SSC Enthusiast

    Points: 136

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

  • mazebane

    Valued Member

    Points: 53

    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 😀

  • krishna85

    Mr or Mrs. 500

    Points: 516

    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 12 (of 12 total)

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