transaction help

[Savas Ates]

im using 2 stored procedure in my asp application...
in my asp page i execute 2 stored .. their works depend on each other...
i want to apply a transaction on these...

must i apply it in stored procedure or in asp page.. any example or any
link...
can u help me about transactions..
i dont have enough info about it...

[Bob Barrows [MVP]]

Re: transaction help

Savas Ates wrote:[color=blue]
> im using 2 stored procedure in my asp application...
> in my asp page i execute 2 stored .. their works depend on each
> other... i want to apply a transaction on these...
>
> must i apply it in stored procedure or in asp page.. any example or
> any link...
> can u help me about transactions..
> i dont have enough info about it...[/color]

Why not have one procedure call the other?

Here is some information about error-handling and transactions:

http://msdn.microsoft.com/library/en-us/dnsqlpro2k/html/sql00f15.asp

There are two articles by Erland here that cover some of the same ground:

http://www.sommarskog.se/

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"