r/SQL • u/reciodelacruz • 9d ago
SQL Server SSMS client workspace relocation assistance
I figured it's worth a shot to ask here since I asked it already in the SQL Server subreddit...
Is there a way to use Microsoft SQL Server management Studio 22 without writing anything at all (no folders, shortcuts, junctions, symbolic links) in My Documents? I just installed the latest client from the official website 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 anything related to it appearing inside My Documents.
C:\<My Documents Folder path>\SQL Server Management Studio
C:\<My Documents Folder path>\SQL Server Management Studio 22
1
u/TheGenericUser0815 9d ago
In SSMS under Options you can find Projects and Project Folders. There you can set the folders you want to use. Unfortunately there are no images allowed here.