November 13, 2016 at 10:29 am
I finally found the settings in the registry and ssms.application.pkgdef file to get the default pathes for STR + O and STR + S for Scripts (*.sql) changed in SSMS 2012. In SSMS 2016 this does not work anymore. Can anyone help how to set them now in SSMS 2016. Thanks in advance
November 13, 2016 at 6:31 pm
If you go into Tools - Options, you will see import/export. That's the file to change. Mine is in VS 2015/Settings/SSMS. Change the ProjectsLocation key.
However, do this when SSMS is not open. It will re-save old settings on close and undo your changes.
November 14, 2016 at 1:49 am
hi steve, i tried this, but its changing the path for opening projects. as i mentioned above, looking for changing the path for scripts, when you edit a script in ssms 2016 with cursor in the script and enter STR + O or STR + S for opening another script or saving one. i could change this in ssms 2012. thanks a lot.
November 14, 2016 at 6:34 am
You need to change the default for SSMS 2016. The fact that your changed 2012 won't have any affect, as they are two distinct Applications.
Locate your SSMS 2016 Installation folder (for example, C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\). Open the Extension Folder, and the the Application Folder.
CLOSE SSMS 2016 COMPLETELY so that the task has ended (not doing this will revert your changes). Open the file ssms.Application.pkgdef in your Application Folder using your preferred text file editor. Amend, or add, the line containing "DefaultProjectsLocation" to your preferred location. For example, mine is "DefaultProjectsLocation"="Y:\SQL Server\Scripts".
Save & Close the file, and then open SSMS 2016.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 14, 2016 at 9:14 am
Hi Thom~, thanks, it worked now for STR + S (saving) a script, STR + O still goes to Desktop, but i could not find the word desktop in your above mentioned file to replace it somehow. regards
November 14, 2016 at 9:52 am
gavin.porter (11/14/2016)
Hi Thom~, thanks, it worked now for STR + S (saving) a script, STR + O still goes to Desktop, but i could not find the word desktop in your above mentioned file to replace it somehow. regards
I'm not sure I ever found a setting for default Open location. I just have a shortcut on my desktop for that.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 14, 2016 at 10:10 am
Hi Thom~,
thanks again, i found it meanwhile. There is a registry entry called DefaultFileOpenLocation under HKCU. I wonder why you could not set up those settings in the application.
November 14, 2016 at 10:55 am
gavin.porter (11/14/2016)
Hi Thom~,thanks again, i found it meanwhile. There is a registry entry called DefaultFileOpenLocation under HKCU. I wonder why you could not set up those settings in the application.
I believe that sets to the last file you opened/saved. For me, it's a strange Github folder for a project I Was working on.
November 15, 2016 at 1:32 am
you are right :-((( i just tested it once, when i save elsewhere it changes. so no solution so far, thanks anyway
June 18, 2020 at 2:40 pm
I found the registry hack for default locations worked for both SSMS and Visual studio but once you save, it becomes the last save location....which I am ok with. However edit the registry at your own peril...it is a path wrought with danger and woe. I do not support or recommend this solution unless you are a qualified professional.
September 20, 2024 at 2:05 pm
My workplace has made sure I am unable to update the ssms.Application. pkgdef file to fix my save locations. Very annoying because none of us can make changes in that directory. So I'm searching for optional methods. Sad to see registry might be my only way of setting DefaultProjectsLocation and DefaultUserFilesFolderRoot.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply