How to add locations to Open File dialog box in SSMS

Question

How to add locations to Open File dialog box in SSMS

SQLUserC

SSCrazy

Points: 2345
More actions
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.

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

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

Todd Engen SSCrazy Eights Points: 9869 More actions · Answer 1

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 More actions · Answer 2

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 More actions · Answer 3

SETH DEBRIERE

SSC Enthusiast

Points: 125

July 23, 2010 at 7:13 am

#1197486

This was GREAT! Thank you.

irina_bit SSC Enthusiast Points: 168 More actions · Answer 4

irina_bit

SSC Enthusiast

Points: 168

December 23, 2010 at 10:13 am

#1266009

Doesn't work for 2008. Any ideas?

Thanks

SQLUserC SSCrazy Points: 2345 More actions · Answer 5

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 More actions · Answer 6

irina_bit

SSC Enthusiast

Points: 168

April 26, 2011 at 12:52 pm

#1316124

working!.. thank you!

Eric Stimpson SSChasing Mays Points: 649 More actions · Answer 7

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 More actions · Answer 8

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 More actions · Answer 9

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

mazebane Valued Member Points: 53 More actions · Answer 10

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: 526 More actions · Answer 11

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