SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to add locations to Open File dialog box in SSMS


How to add locations to Open File dialog box in SSMS

Author
Message
SQLUserC
SQLUserC
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 328
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
Todd Engen
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1523 Visits: 6336
Here's where you'd find that for SSMS with 2005.

\HKCU\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\Open Find\Places\UserDefinedPlaces

Add subkeys Place0,Place1,Place(n)

Under each subkey add two REG_SZ values

Name = "Shortcut Name"
Path = "Folder location"

SQLUserC
SQLUserC
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 328
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
SETH DEBRIERE
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 60
This was GREAT! Thank you.
irina_bit
irina_bit
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 21
Doesn't work for 2008. Any ideas?
Thanks
SQLUserC
SQLUserC
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 328
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
irina_bit
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 21
working!.. thank you!
Eric Stimpson
Eric Stimpson
SSC-Enthusiastic
SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)

Group: General Forum Members
Points: 113 Visits: 115
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
SQLUserC
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 328
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
treusch
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 24
This is an old post, but just wanted to add a "Thanks!" This worked great for me!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search