OnBeginTransaction And OnCommitTransaction  
Author Message
mikeburg





PostPosted: Wed Jul 11 04:34:09 CDT 2007 Top

SQL Server Developer >> OnBeginTransaction And OnCommitTransaction

As I need to do some tasks when Begin Transaction and Commit Transaction
raised,
How can I do to like OnBeginTransaction Event() And OnCommitTransaction() on
SQL Server?

SQL Server141  
 
 
Erland





PostPosted: Wed Jul 11 04:34:09 CDT 2007 Top

SQL Server Developer >> OnBeginTransaction And OnCommitTransaction
> As I need to do some tasks when Begin Transaction and Commit Transaction
> raised,
> How can I do to like OnBeginTransaction Event() And
> OnCommitTransaction() on SQL Server?

Maybe you could explain what you want to achieve in more general terms
what you want to achieve, rather than describing a solution.

But if I am to guess what you are after: there are no way to trap that
a transaction starts or commits.


--


Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx