Is it possible to put stored procedure calls into the Transaction Code
option instead of Insert statements using the BeginTransaction code for
ADO.net ?
 I have some pretty large transactions so I am concerned with speed and
reliablity.

 For example instead of building the "insert into statement" into the
BeginTransaction
and then doing an .ExecuteScaler, Is it possible put the stored procedure
there and
then ExecureScaler for each stored procedure.

Now If there is an error should i , raise the error in the store procedure
and roll back the transaction via the
vb code or do i roll back the transaction inside the stored procedure and
fail out of the vb code?

Any help with this would be greatly appriciated.

Eric

See the BeginTransaction topic in the help file (there's also a quick
start tutorial on it i believe). However, you may find it more
efficient to implement your transactions in T-SQL inside of the stored
procedure(s), in which case see the Explicit Transactions topic in SQL
BooksOnline.

-- Mary
MCW Technologies
http://www.mcwtech.com

On Mon, 17 Feb 2003 16:38:18 -0600, "Eric John Seneca"