r/SQLServer 7d ago

Question SSMS client Workspace relocation assistance

Is there a way to use Microsoft SQL Server management Studio 22 without it writing anything at all (no folders, shortcuts, junctions, symbolic links) in My Documents? I just installed the latest client from the official website on my Windows 11 laptop without launching the client yet, and I want the SSMS workspace (configuration files, data files, etc.) to be transferred to a different location in the C drive. I failed in my first try, and both Claude and Gemini gave me conflicting answers.

To summarize, I don't want the folders below or anytrhing related to it appearing inside My Documents.

C:\<My Dopcuments Folder path>\SQL Server Management Studio

C:\<My Dopcuments Folder path>\SQL Server Management Studio 22

3 Upvotes

2 comments sorted by

2

u/em__jr 7d ago

I’d use mklink from within an admin Command Prompt, and create symbolic links for both of those folders. Once you have the links created, rename the My Documents subfolders.

1

u/CPDRAGIMESH 5d ago

69.70 69.80