How to find the time taken for rollback of the processed?
- 1 Answers
- 1096 Views
- I also Faced
- E-Mail Answers
Answer Posted / Naz Mehdi
To find the time taken for a rollback in Sybase, you can use the SQL Server's built-in function @@TRANCOUNT and the system function GETDATE(). You would first execute your transaction, then check the value of @@TRANCOUNT to see if there are any open transactions. If there are, you can calculate the time taken for the rollback by subtracting the initial GETDATE() from the final GETDATE() after the rollback.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
