How to change defualt directory for saving files from SSMS?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How to change defualt directory for saving...

How to change defualt directory for saving files from SSMS?

Rate Topic

Display Mode

Topic Options

Author

Message

MaxNevermind

Posted Tuesday, January 22, 2013 1:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 11:51 AM
Points: 6, Visits: 28

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

Post #1409851

runaldo

Posted Tuesday, January 22, 2013 4:08 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 5:23 AM
Points: 74, Visits: 435

Tools - Options - Query Results - SQL Server

Post #1409914

MaxNevermind

Posted Tuesday, January 22, 2013 4:18 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 11:51 AM
Points: 6, Visits: 28

It doesn't work:
I changed it
Reopened SSMS
Createed a new sql-script
Tried to save it - the folder didn't change

Post #1409921

Lowell

Posted Tuesday, January 22, 2013 4:27 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:39 PM
Points: 11,638, Visits: 27,713

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1409927

MaxNevermind

Posted Tuesday, January 22, 2013 4:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 11:51 AM
Points: 6, Visits: 28

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?

Post #1409930

MaxNevermind

Posted Tuesday, January 22, 2013 5:15 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 11:51 AM
Points: 6, Visits: 28

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

Post #1409961

« Prev Topic | Next Topic »

Permissions