| Home | About Us | Sybase Training | Synergy | Consulting | Job Openings | Tech Videos | Rules and Disclaimer | Search |
|
 |
![[-]](images/Nova/collapse.gif) Synergy-Work with SybaseTeam
|
We are looking for enthusiastic Sybase IQ DBA's/Developers who can work with us to provide Training services for SybaseTeam clients/users. If interested, please send an email to Synergy@SybaseTeam.com with your profile attached. Looking forward to work in collaboration.Together we can make it happen ! - Synergy Dept.(SybaseTeam.Com) |
Sybase Forums,Unix Forums-Sybase ASE|Replication Server|IQ|Sybase SUP|Unix|Perl| Sybase Training
›
Sybase IQ, formally Sybase Adaptive Server IQ
›
Sybase IQ Interview Questions and Answers
How do I kill a detached transaction in Sybase
|
How do I kill a detached transaction in Sybase
|
|
10-02-2009, 02:28 PM
Post: #1
|
|||
|
|||
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. |
|||
|
|
06-14-2012, 02:16 AM
Post: #2
|
|||
|
|||
|
bouce the server only .
|
|||
|
|
|
06-15-2012, 01:39 AM
Post: #3
|
|||
|
|||
|
Hi, Try using dbcc complete_xact command. Regards, kdeshpan |
|||
|
|
|
« Next Oldest · Next Newest »
|
| Possibly Related Threads... | |||||
| Thread: | Author | Replies: | Views: | Last Post | |
| How does a detached transaction impact kills in Sybase | albert | 0 | 1,226 |
10-02-2009 02:27 PM Last Post: albert |
|
| What is a detached transaction in Sybase | albert | 0 | 1,540 |
10-02-2009 02:25 PM Last Post: albert |
|