When copying from SQL Search, this error message may be displayed:
To stop this happening:
- Close all query windows.
Alternatively, you can restart SSMS after following these steps.
- Go to Tools -> Options.
- Under the Environment section, select Documents.
- Deselect the Show Miscellaneous files in Solution Explorer checkbox:
- Click OK.
Copy and paste should now work normally when there are unsaved query windows open.