SSMS default projects folder

SSMS default projects folder

SSMS default projects folder 150 150 Carlos L Chacon

I have a client that wants to ability to see the ad-hoc queries/scripts I write for them.  These aren’t things that go into production or a source control environment.  While it is only a couple of clicks, it became tediuos to change my directory folder every time I wanted to save or open an script.  The default location for saving your files in SSMS can be changed by editing the My DocumentsSQL Server Management StudioSettingsCurrentSettings-[Date].vssettings file.

As always–give yourself a way to get back and take a backup before you edit the file.

You are looking for the part of the file that says <PropertyValue name=”ProjectsLocation”>%vsspv_user_documents%My Projects</PropertyValue>.  Mine was on the first line way to the right.  I had SSMS closed when I edited the file and changed the location to a network share.  I opened SSMS again and it opened right to network location.  If for some reason it doesn’t do that, you can click on the ‘My Projects’ folder on the left and it should take you there.

Imagine what’s possible with a dedicated SQL specialist on your team.

Leave a Reply

Back to top