[himanshu.tomar]

Hi Guys,
I am facing a problem while doing the rollback in sql server 2000 using VB.Net.
By using the conventional Method::

Dim transaction as SqlTransaction
SetConnection()
transaction = Con.BeginTransaction
</ sample code/>
transaction.commit
and getting error
transaction.rollback
But the above method is not working in my code.
I tried the code written below but is not able to implement in stored procedure.

begin transaction
insert into delete_demo values(7,'Aar3')
insert into delete_demo values(2,'Aakr')
if(@@error<>1)
commit transaction
else
rollback transaction

Any help is most welcomed....

[dineeshd]

A typical SQL Server Transaction statement should be as below..

Begin transaction MyTrans
	
/* Your code here */

if (@@error <> 0)
begin
	print 'Modification failed!'
	goto on_transaction_failed
end

Commit Transaction MyTrans

print 'The execution completed successfully'

goto on_complete

on_transaction_failed:

begin		
	rollback transaction trans
	print 'Rolled back successfully'
	goto on_complete
end

on_complete: