You are not logged in or registered. Please login or register to use the full functionality of this Website SybaseTeam.Com...
Hello There, Guest! (LoginRegister) Remember Me? Current time: 07-29-2014, 09:54 PM
   Home  |  About Us  |  Sybase Training  |  Synergy  |  Consulting  |  Job Openings  |  Tech Videos  |  Rules and Disclaimer  |  Search
Post Reply 
Forum Tools
How do I kill a detached transaction in Sybase
10-02-2009, 02:28 PM
Post: #1
Quote this message in a reply
How do I kill a detached transaction in Sybase


How do I kill a detached transaction in Sybase

To abort a detached transaction, clear the block with heuristic completions. The "kill" command does not work on detached transactions because "kill" applies only to threads, and detached transactions are not attached to threads.


Find all posts by this user
06-14-2012, 02:16 AM
Post: #2
Quote this message in a reply
RE: How do I kill a detached transaction in Sybase


bouce the server only .


Find all posts by this user
06-15-2012, 01:39 AM
Post: #3
Quote this message in a reply
RE: How do I kill a detached transaction in Sybase


Hi,
Try using dbcc complete_xact command.


Regards,
kdeshpan


Find all posts by this user
Post Reply 


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  How does a detached transaction impact kills in Sybase albert 0 1,951 10-02-2009 02:27 PM
Last Post: albert
  What is a detached transaction in Sybase albert 0 2,576 10-02-2009 02:25 PM
Last Post: albert

Options:
Forum Jump:


Contact Us | SybaseTeam | Disclaimer & Rules | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication