sql server Mgmt server "Save File As" default folder

• dwolver

  SSC Veteran

  Points: 285

  More actions

  May 27, 2010 at 9:07 am

  #219518

  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.

• Renuka__

  Hall of Fame

  Points: 3656

  More actions

  May 27, 2010 at 9:31 am

  #1173412

  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]

• dwolver

  SSC Veteran

  Points: 285

  More actions

  May 27, 2010 at 12:53 pm

  #1173535

  Looks like the easiest way to do this is to open up the default folder and paste a shortcut to my "desired" folder.

• WayneS

  SSC Guru

  Points: 95461

  More actions

  May 27, 2010 at 1:48 pm

  #1173574

  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

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2