Viewing 2 posts - 1 through 2 (of 2 total)
Try undocumented DBCC PSS with your SPID, it should sugest the status of the process, and then you can decide whether you can rollback it or take some other action.
...
December 16, 2003 at 4:34 am
#486350
Hi Frank,
At last we had to go by the EM way..though it was very lengthy and time cosuming to change the objects, that too when they have millions of rows...
December 16, 2003 at 4:22 am
#486348