Edit

Share via


Workaround to enable copying from Find and Replace window

Applies to: SQL Server Azure SQL Database Azure Synapse Analytics Not supported. 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:

  1. In the Tools menu, open Options.

  2. Under Environment > Documents, uncheck the item for Show Miscellaneous files in Solution Explorer.

  3. Close and reopen SQL Server Management Studio.