更改 SQL Management Studio 2008 的默认保存位置
正如标题所示，我该如何做到这一点？
我想点击“保存”，然后让 SSMS 自动将我定向到网络文件夹。
As the title states, how do I do this?
I want to hit save, and have SSMS automatically direct me to a network folder..
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
这已经有 3 年历史了，但是 SSMS 2012 和 2014 的答案会很有帮助，所以我想我应该添加一个更新。第一步因版本而异，其余部分相同：
SSMS 2012
< strong>SSMS 2014
两者（续）
感谢此来源:<一href="http://www.networksteve.com/forum/topic.php/How_to_change_the_default_query_save_location_in_SSMS/?TopicId=41425&Posts=0" rel="noreferrer">http://www.networksteve.com/forum/topic.php/How_to_change_the_default_query_save_location_in_SSMS/?TopicId=41425&Posts=0
This is 3 years old now, but an answer for SSMS 2012 and 2014 would be helpful, so I thought I'd add an update. Step one differs between the versions, and then the rest is the same:
SSMS 2012
SSMS 2014
Both (continued)
Thanks to this source: http://www.networksteve.com/forum/topic.php/How_to_change_the_default_query_save_location_in_SSMS/?TopicId=41425&Posts=0
2k8 在注册表中的正确位置是
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell。The correct location for 2k8 in the registry is
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell.它无法在工具内编辑（出于某种原因），但您可以从“我的文档”>“设置”文件中调整它。 SQL Server Management Studio >设置。
查找节点“ProjectsLocation”，并进行相应调整 -
请务必在编辑此文件之前退出 SSMS。这应该可以解决问题...
It's not editable from within the tool (for some reason), but you can adjust it from the settings file within My Documents > SQL Server Management Studio > Settings.
Look for the node "ProjectsLocation", and adjust accordingly -
<PropertyValue name="ProjectsLocation">\\mynetworkpath</PropertyValue>Be sure to exit SSMS before editing this file. This should do the trick...
@Kevin 的解决方案 不不适用于 SQL 2k8。需要更改注册表：
现在看看他们在哪里写入默认路径...将其更改为任何有效的 UNC。
@Kevin's solution doesn't work for SQL 2k8. One needs to change the registry:
Now see where they wrote the default path... change that into any valid UNC.
在经历了很多笨拙之后，这似乎对我有用 -
按照上面的帖子中所述编辑注册表设置（HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell） - 更改除 MyDocumentsLocation 之外的所有路径（这是似乎导致设置重置的原因）。
从“我的文档”中找到 .vssettings 文件，并将其复制到您的文件夹 +“/Settings”文件夹（例如 c:\Dox\SQL Server Management Studio\Settings）。
启动 SQL studio，退出并重新启动。
编辑 .vssettings 文件（现在应该位于您的文件夹中，而不是“我的文档”中），并将 ProjectsLocation 更改为所需的文件夹，例如 C:\Dox\SQL Server Management Studio\Projects
启动 SQL studio。现在应该可以打开文件，但保存需要单击保存对话框左侧的“我的项目”。
This seems to work for me after a lot of bungling -
Edit registry settings as outlined in above posts (HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell) - change all the paths EXCEPT MyDocumentsLocation (this is what seems to cause the settings to get reset).
Locate the .vssettings file from My Documents and copy to your folder + '/Settings' folder (e.g. c:\Dox\SQL Server Management Studio\Settings).
Start SQL studio, quit and restart.
Edit the .vssettings file (should be in your folder now rather than My Documents), and change the ProjectsLocation to the desired folder e.g. C:\Dox\SQL Server Management Studio\Projects
Start SQL studio. Opening files should now work, but save will require clicking the 'My Projects' on the left of the save dialog.