May 27, 2010 at 9:07 am
When I run a query in sql server managment server and want to save it, the File Save As dialog always defaults to My Documents\SQL Server Management Studio\Projects. Is there a way to change this, I cant seem to locate anything under tools->options other than default location for query results.
May 27, 2010 at 9:31 am
Hi,
Tools-->Options-->Query Results-->Default location for saving query results--> <Your path>
Thank you
Oops...Sorry -- I just noticed you are asking about saving query, not the result. It may be a registry change?!!?
[font="Verdana"]Renuka__[/font]
May 27, 2010 at 12:53 pm
Looks like the easiest way to do this is to open up the default folder and paste a shortcut to my "desired" folder.
May 27, 2010 at 1:48 pm
Check out this link for how to add to the "My Places" bar on the left side of the open/save as dialog box. Note that the instructions are for SSMS 2008 - change the \100\ to \90\ for 2005.
You can make a reg file to set it up also, i.e.:
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\Open Find\Places\UserDefinedPlaces]
"Show"="1"
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\Open Find\Places\UserDefinedPlaces\Places1]
"Name"="DBA"
"SortAscending"=dword:00000001
"Path"="C:\\DBA"
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply