====== {$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 [[how-to_write_sql_to_extract_an_xml_value_from_a_database_field|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 =====
  * Entered : 10/26/2010
  * Version :



===== Related SQLs =====
  * Backlinks [[include_pagepage_componentbacklinks]]