SSMS insists on creating the following folders every time it is run:
%USERPROFILE%\Documents\SQL Server Management Studio
%USERPROFILE% is an environment variable, with mine being
In File Manager (AKA - Windows Explorer), I set the location for my documents to be on my OneDrive, like:
And everything works fine. Until … Another program decides that it will use
%USERPROFILE%\Documents as the location for “my documents”. Some programs will not find the
%USERPROFILE%\Documents and then adjust the open or save dialog to a valid location. This is fine (and preferred). While others (like SSMS) will create the “missing” subfolders as it deems necessary.
%USERPROFILE%\Documents directory does exist, some programs will default to that folder.
A couple of issues arise:
The files in
%USERPROFILE%\Documentsaren’t backed up to the cloud or available on other devices that have access to OneDrive.
It’s hard to keep straight which location (under the c:\users\username folder vs the OneDrive folder) has the files I need.
Using File Manger and browsing to my profile, I see I have a folder named “Documents” (generic folder icon), as well as one named “Documents” (identical name, but with a “library” type icon).
The yellow Documents folder (dated 9/1/2021) has just a single sub-folder (SSMS), with no files in it. I can delete the SSMS sub folder (leaving “Documents” empty), but cannot delete the Documents folder.
Anyone run into issues with moving the location of your “Documents” folder, from the default location of