Hi

If I've understood your question, you've saved your code using 'Save solution'. If your SQL was copied into a new query window then you would have been prompted for a file to save to. This will generally go to 'User Directory\My Documents\SQL Server Management Studio\Projects'. You should also be able to get to it from the 'Recent' drop down menu in the 'File' menu.

Personally for large SQL scripts I try to break them up into smaller more manageable chunks and merge them back together to run if necessary. Most of the time this isn't necessary though.

Micky