Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
selvasuresh17
Starting Member
3 Posts |
 Posted - 2010-05-06 : 12:47:53
|
| Hi all, I have to execute the SQL query of 148 mb,i have been trying to execute the script and it shows as if query is executing.But even after 24 hours nothing is getting executed and no impact in database objects.Can anyone help how to execute the entire script ?thanks,Selvasuresh. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-05-06 : 15:20:44
|
| If possible do not run the script in a Transaction-block.Also, make sure there are plenty of "GO" statements within the script so that it can run "in batches"However, if the script fails you will need to restore from backup as the script will have completed in part when it fails. |
 |
|
|
|
|
|
Huge size of SQL script to be executed
Tara Kizer