Sql-server – Importing a large SQL script into SQL Server

The only way to do this is by having set up some form of monitoring process prior to (and during) the operation. E.g. the Profiler tool allows you to log the duration of (and any statements, but not results) of any batch, or you could issue a SELECT or PRINT showing the results of getdate() prior to, and after, the statement.

With modification operations like a DELETE, there will be a record in the transaction log (assuming it hasn't been truncated since, with a log backup or a checkpoint in simple recovery mode), but mere mortals can't inspect the transaction log with built-in tools. Third-party log inspectors are available though, but the transaction log shows the time an operation occurred, it doesn't contain information about its duration :)

I realise that this is shutting the gate after the horse is bolted, but there's no built-in record of things like this that will survive a reboot, sorry!

If you have an appropriate MDF and LDF file you should be able to attach them within Management Studio by right clicking on the databases folder under your server name in Object Explorer and selecting attach database. Alternatively you can use T-SQL to attach your database files - although you may find the GUI easier to do so.

This link will describe how to do so step by step: http://msdn.microsoft.com/en-us/library/ms190209.aspx

Alternatively to run the script Visual Studio gave you, if you right click on the server name and choose new query you can paste the script here and execute it (use F5 to execute) to run the script.