transaction, commits and rollbacks HOW TO

NEED to apply transactions, commits and rollback to a script with a lot of inserts (sql server)

thanks anyone.

There have been quite some threads about it. Like

http://www.codingforums.com/showthread.php?s=&threadid=19116&highlight=transaction

Originally posted by atferraz
NEED to apply transactions, commits and rollback to a script with a lot of inserts (sql server)

thanks anyone.

Hi,

You can do the transactions from your ASP code using ADO:

' oConn is your ADO connection object
oConn.BeginTrans
oConn.CommitTrans
oConn.RollbackTrans

or you can do your transactions within your stored procedures in the SQL Server.

thank you all. got that.