Dear Smokers, please get a plastic bag and cover yourself whenever you want to start smoking to enable you to enjoy the smoke 100% by yourself. I don’t want any percentage of it nor do my friends who don’t smoke. Don’t kill me if you want to kill yourself. Regards, Non-smokers. Source : facebook,twitter and… Continue reading
The last method (workaround) to solve a lock status is by killing the process. Write this line to Kill a process in sql server:
|
1 2 3 4 |
--This example shows how to terminate SPID 55. KILL 55 --This example generates a status of the rollback process for the specific spid. KILL 55 WITH STATUSONLY |
–This is the progress report.spid 55: Transaction rollback in progress. Estimated rollback completion: 70% Estimated time left: 15 seconds.