> -----Original Message-----
> - if you commit inside SP, what will happen to subsequent
> commands in SP,
> will they raise exception ?

In SQL Server you can start and then commit/rollback a transaction within a
stored procedure which is sometimes handy.

Rgds

Si Carter
http://www.tectsoft.net/
http://www.fbtalk.nt/