Script to check ANSI_NULLS option on stored procedures

• mike-306849

  SSChasing Mays

  Points: 607

  More actions

  May 7, 2008 at 10:52 am

  #190301

  Does anyone know of a quick way to see how the ANSI_NULLS option is set on all procedures in a database?

• mike-306849

  SSChasing Mays

  Points: 607

  More actions

  May 7, 2008 at 11:43 am

  #811974

  Nevermind, I did find one using the objectproperty function.

  http://www.sqlmag.com/Article/ArticleID/95960/Optimizing_Queries_for_Fact_Tables.html