Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to change defualt directory for saving files from SSMS? Expand / Collapse
Author
Message
Posted Tuesday, January 22, 2013 1:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 1, 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
Posted Tuesday, January 22, 2013 4:08 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 1:32 AM
Points: 83, Visits: 515
Tools - Options - Query Results - SQL Server


Post #1409914
Posted Tuesday, January 22, 2013 4:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 1, 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
Posted Tuesday, January 22, 2013 4:27 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 12,905, Visits: 32,168
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
Posted Tuesday, January 22, 2013 4:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 1, 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
Posted Tuesday, January 22, 2013 5:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 1, 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 »

Add to briefcase

Permissions Expand / Collapse