Management Studio 默认文件保存位置 [英] Management Studio default file save location

问题描述

打开一个新的查询窗口.写一些SQL.保存脚本，文件另存为对话框打开 - 但总是在配置文件中的相同默认位置目录.有没有办法设置我的默认文件位置?...就像我用过的与 1980 年代的应用有关吗?

在工具|选项下，可以为查询结果指定默认位置.对于新查询(文本编辑器)，我需要同样的东西.尝试改变位置在注册表中，但 SSMS 只是覆盖了我的更改.任何建议?

(我在 http://www.eggheadcafe.com/software/aspnet/30098335/management-studio-default.aspx我有同样的问题，所以我只是在这里重新发布)

解决方案

我知道这是一个老问题，但我找到了一个链接，解释了如何正确执行此操作，至少对于 SQL 2005.认为它适用于更高版本

更改我的项目文件夹

<块引用>

设置存储在 My Documents\SQL Server Management Studio\Settings 文件夹中的 .vssettings XML 文件中.确保关闭 SSMS在对此文件进行更改之前:SSMS 在您关闭时写入它应用程序，并将覆盖您所做的任何更改.要更改My Projects 文件夹，你正在寻找这一行:

 %vsspv_user_documents%\My项目</PropertyValue>

<块引用>

里面的值是 My Projects 文件夹的位置.简单地更改值，下次打开 SSMS 时，My Projects文件夹将被映射.

Open a new query window. Write some SQL. Save the script, the Save File As dialog box opens - but always to the same default location in the Profiles directory. Is there any way to set my default file location? ...Like I used to do with apps from the 1980s?

Under Tools|Options a default location can be specified for query results. I need the same thing for new queries (the text editor). Tried changing locations in the Registry but SSMS just overwrote my changes. Any suggestions?

(I saw this unanswered question at http://www.eggheadcafe.com/software/aspnet/30098335/management-studio-default.aspx and I had same exact question so I just reposted it here)

解决方案

I know this is an old question, but I found a link expaining how to do this properly, at least for SQL 2005. Think it will work for later versions as well.

Changing the my projects folder

The settings are stored in an .vssettings XML file in My Documents\SQL Server Management Studio\Settings folder. Make sure you close SSMS before making changes to this file: SSMS writes to it when you close the application and will overwrite any changes you make. To change the My Projects folder, you are looking for this line:

   <PropertyValue name="ProjectsLocation">%vsspv_user_documents%\My
   Projects</PropertyValue>

The value inside is the location of the My Projects folder. Simply change the value, and the next time you open SSMS the My Projects folder will be mapped.

这篇关于Management Studio 默认文件保存位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！