I had 5 SPIDS that run SSIS Packages.
Each process was stuck on the Step that executes an OPENQUERY that does a SELECT COUNT(*) to get the record counts in AS400 Tables.
I stopped all of the jobs but the SPID is still executing the OPENQUERY.
I killed on of the SPIDS but when I execute the KILL 54 WITH STATUSONLY I get :
SPID 54: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.
It has been stuck for about 30 minutes.
There are no connections to the AS400.
This thing is not going to complete the Rollback.
What can I do?
I'm currently copying the backups to another Server and plan on restoring them.
I do not want to restart the Service and have the Database go into recovery.
Isn't there a command to take offline and ignore open transactions or something to that?
For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/