rollback all transaction - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

rollback all transaction

Author

Topic

veronika.np
Starting Member

29 Posts

Posted - 2011-06-17 : 12:57:31

hi friends
i have a problem.i want to rollback all of open transaction.
how do i it?
olease help me.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-17 : 12:59:32

If it's for other spids, then just KILL them. If it's for your spid, then you can KILL it or do ROLLBACK TRAN.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

veronika.np
Starting Member

29 Posts

Posted - 2011-06-17 : 13:04:52

quote:
Originally posted by tkizer

If it's for other spids, then just KILL them. If it's for your spid, then you can KILL it or do ROLLBACK TRAN.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

how can i do it?i dont know what is it1s script.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-17 : 13:27:55

KILL 93 (use sp_who/sp_who2 or sysprocesses to find the spids, 93 is just an example spid number, you will need to change it)

ROLLBACK TRAN

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources