How to change defualt directory for saving files from SSMS?

Question

Post reply

How to change defualt directory for saving files from SSMS?

MaxNevermind

SSC Enthusiast

Points: 124
More actions
January 22, 2013 at 1:19 am

#267528

I mean sql-scripts. Now It saves only for a current session, after each reopening of SSMS I have to show my derictory again.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

runaldo SSCommitted Points: 1682 More actions · Answer 1

runaldo

SSCommitted

Points: 1682

January 22, 2013 at 4:08 am

#1579529

Tools - Options - Query Results - SQL Server

MaxNevermind SSC Enthusiast Points: 124 More actions · Answer 2

It doesn't work:

I changed it

Reopened SSMS

Createed a new sql-script

Tried to save it - the folder didn't change

Lowell SSC Guru Points: 323518 More actions · Answer 3

i had to poke around to find this; it involves editing an xml file:

http://visualstudiohacks.com/options/changing-the-my-projects-folder-location-and-other-settings-in-ssms/

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

MaxNevermind SSC Enthusiast Points: 124 More actions · Answer 4

Lowell (1/22/2013)
i had to poke around to find this; it involves editing an xml file:
http://visualstudiohacks.com/options/changing-the-my-projects-folder-location-and-other-settings-in-ssms/

lol

I just found it and it doesn't work for me. Does it work for you?

MaxNevermind SSC Enthusiast Points: 124 More actions · Answer 5

I found 5 similar topics on MS community, none of them has a working solution:

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/50a5a769-3a42-4958-b76f-a5885296bd4a/

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/99531920-51ad-4985-8fe6-cf2f33e7fccb

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/ade9b4b9-63ef-4639-9be5-d4159b247bac

http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/2b743982-c07e-46d4-83aa-1d29249a75f5

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/7e6e7320-1122-41b4-af47-5059936814c4