Table of Contents

{$page}

Explanation of SQL

This query will set the database option for Numeric_RoundAbort to false. This option is necessary for certain queries to function properly. For example, the XML Extraction Query requires this option to be set, this query will globally set the option, so that it is not necessary for be called each time the query is executed.

Risk of Data Corruption if Run Improperly

None. This is a selection query and no data is modified in the running of it.

SQL

code_formatsql

sp_dboption '', 'numeric roundabort', 'false'

code

Version Information