SQL Search 2

Unsaved documents cannot be cut or copied to the clipboard from the Miscellaneous Files project

When copying from SQL Search, this error message may be displayed:

Microsoft SQL Server Management Studio: 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.

Solution

To stop this happening:

  1. Close all query windows.
    Alternatively, you can restart SSMS after following these steps. 
  2. Go to Tools -> Options.
  3. Under the Environment section, select Documents.
  4. Deselect the Show Miscellaneous files in Solution Explorer checkbox:
  5. Click OK.

Copy and paste should now work normally when there are unsaved query windows open.


Didn't find what you were looking for?