Unix Technical Forum

Use of set xact_abort on/off

This is a discussion on Use of set xact_abort on/off within the SQL Server forums, part of the Microsoft SQL Server category; --> Is there any reason to use set xact_abort on OR set xact_abort off as a rule in my stored ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

Use of set xact_abort on/off Use of set xact_abort on/off

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 02-29-2008, 08:30 AM
laurenq uantrell
 
Posts: n/a
Default Use of set xact_abort on/off
Is there any reason to use set xact_abort on OR set xact_abort off as a
rule in my stored procedures?

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-29-2008, 08:30 AM
Simon Hayes
 
Posts: n/a
Default Re: Use of set xact_abort on/off
http://www.sommarskog.se/error-handl...tml#XACT_ABORT
http://www.sommarskog.se/error-handl...tml#XACT_ABORT

Simon

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Using NOT EXISTS in an INSERT procedure | ADODB connection with SQL2000SP3 »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:50 PM.

Contact Us - Unix Technical Forums - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com