Home Forums SQL Server 2012 SQL 2012 - General Need to see the value of set option NUMERIC_ROUNDABORT for all the sessions RE: Need to see the value of set option NUMERIC_ROUNDABORT for all the sessions

  • I've checked it with sys.sql_modules. Was surprised to find 2 procedures with the wrong setting options. Those procedures have nothing to do with the tables that I want to add the filtered index on them, and in fact I'm not even sure that they are still being used by any of the applications that work with the database.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/