Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Sybase > Can I tell if a...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 2412 of 2512
Post > Topic >>

Can I tell if arithabort numeric_truncation is set using a T-SQL

by david.rawheiser@[EMAIL PROTECTED] Feb 28, 2008 at 10:20 AM

At the site where I am working now ...

There are multiple places in calling and called procedures where "set
arithabort numeric_truncation" is turned off and back on again.

Each proc that turns it off, then turns it back on again after it
exists, meaning that the calling proc no longer has the setting it
expects.

Is there a way to determine in T-SQL the state of this global
setting?  So that I can have a called proc know enough to leave it off
when exiting, like I could for transactions using @[EMAIL PROTECTED]

 




 3 Posts in Topic:
Can I tell if arithabort numeric_truncation is set using a T-SQL
david.rawheiser@[EMAIL PR  2008-02-28 10:20:37 
Re: Can I tell if arithabort numeric_truncation is set using a T
bret@[EMAIL PROTECTED]   2008-02-28 15:24:33 
Re: Can I tell if arithabort numeric_truncation is set using a T
bret@[EMAIL PROTECTED]   2008-03-03 08:40:29 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 1:01:40 CDT 2008.