Cannot repoint "SQL Server Management Studio" directory

%3CLINGO-SUB%20id%3D%22lingo-sub-2475336%22%20slang%3D%22en-US%22%3ECannot%20repoint%20%22SQL%20Server%20Management%20Studio%22%20directory%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2475336%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20starting%20SQL%20Server%20Management%20Studio%2C%20a%20directory%20gets%20created%20at%20%22C%3A%5CUsers%5C%3CMYUSERID%3E%5CDocuments%5CSQL%20Server%20Management%20Studio%22%2C%20and%20I%20can%20find%20no%20way%20to%20point%20it%20somewhere%20else.%26nbsp%3B%3C%2FMYUSERID%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20initially%20set%20%22Tools%20%2F%20Options%20%2F%20Projects%20and%20Solutions%20%2F%20Locations%20%2F%20Projects%20location%22%20in%20SSMS%20to%20a%20new%20location%2C%20thinking%20that%20this%20was%20the%20right%20config%20value%20to%20change.%26nbsp%3B%20But%20even%20after%20setting%20it%20to%20a%20new%20location%2C%20a%20directory%20still%20gets%20created%20at%26nbsp%3B%22C%3A%5CUsers%5C%3CMYUSERID%3E%5CDocuments%5CSQL%20Server%20Management%20Studio%22.%3C%2FMYUSERID%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20searched%20the%20Registry%20and%20found%20%22Computer%5CHKEY_CURRENT_USER%5CSOFTWARE%5CMicrosoft%5CSQL%20Server%20Management%20Studio%5C18.0_IsoShell_Config%5CDefaultProjectsLocation%22.%26nbsp%3B%20Changing%20that%20key%20seemed%20to%20work%20for%20one%20SSMS%20restart%2C%20but%20after%20starting%20SSMS%20a%20second%20time%2C%20the%20key%20got%20reset%20by%20something%20back%20to%26nbsp%3B%22C%3A%5CUsers%5C%3CMYUSERID%3E%5CDocuments%5CSQL%20Server%20Management%20Studio%22%2C%20and%20the%20directory%20got%20created%20there.%3C%2FMYUSERID%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20move%20%22C%3A%5CUsers%5C%3CMYUSERID%3E%5CDocuments%5CSQL%20Server%20Management%20Studio%22%20to%20a%20different%20location%3F%3C%2FMYUSERID%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When starting SQL Server Management Studio, a directory gets created at "C:\Users\<myuserid>\Documents\SQL Server Management Studio", and I can find no way to point it somewhere else. 

 

I initially set "Tools / Options / Projects and Solutions / Locations / Projects location" in SSMS to a new location, thinking that this was the right config value to change.  But even after setting it to a new location, a directory still gets created at "C:\Users\<myuserid>\Documents\SQL Server Management Studio".

 

I also searched the Registry and found "Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\SQL Server Management Studio\18.0_IsoShell_Config\DefaultProjectsLocation".  Changing that key seemed to work for one SSMS restart, but after starting SSMS a second time, the key got reset by something back to "C:\Users\<myuserid>\Documents\SQL Server Management Studio", and the directory got created there.

 

How do I move "C:\Users\<myuserid>\Documents\SQL Server Management Studio" to a different location?

0 Replies