Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to:
SQL Server
Azure SQL Database
Azure Synapse Analytics
Analytics Platform System (PDW)
For SQL Server Management Studio (SSMS) 21 and earlier versions, a workaround is required to enable copying from the Find and Replace window. If you can't copy from the Find and Replace window in SSMS, follow the workaround. This problem doesn't exist in SSMS 22 and later versions.
Error message
When you attempt to copy text from the Find and Replace window in SQL Server Management Studio, you might get the following error message.
Unsaved documents cannot be cut or copied to the clipboard from the Miscellaneous Files project. You must save the unsaved document(s) before cutting or copying them.
Workaround
To enable copying text from the Find and Replace window, follow these steps:
In the Tools menu, open Options.
Under Environment > Documents, uncheck the item for Show Miscellaneous files in Solution Explorer.
Close and reopen SQL Server Management Studio.