Re: implicit transactions

James K. Lowden wrote:
> As Peter suggests, 
> 
> 	sp_configure 'user options', 0
> 
> or, to turn off only implicit transactions, 
> 
> 	sp_configure 'user options', 4484

Peter also mentioned you need to execute the RECONFIGURE statement to put
the new "user options" in effect.  

I should also correct myself: sp_configure sets server options, not
database options.  (I'm not a DBA.)  

You may also find this helpful to understand what's going on:

http://msdn.microsoft.com/en-us/library/aa196114(SQL.80).aspx

--jkl