i have used
commit transaction;
in sql server 2005 but i am getting a error like
Msg 3902, Level 16, State 1, Line 1
The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
can...