Post reply

Set options total 249?

  • June 14, 2011 at 11:19 pm

    #389734

    What are the set options when total is 249?

  • June 15, 2011 at 12:11 am

    #1338772

    Where did that total come from, and have you checked Books Online?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 15, 2011 at 3:29 am

    #1338835

    Could be XML indexes, as referred your best bet is latest Books online for SQL 2005.

    -Satya SK Jayanty
    SQL Server MVP (Follow me @sqlmaster)
    Author of SQL Server 2008 R2 Administration CookBook
    SQL Server Knowledge Sharing network

  • June 15, 2011 at 3:34 pm

    #1339346

    -- good for checking options programmatically

    SELECT @@OPTIONS AS user_options ;

    GO

    --much nicer for humans

    DBCC USEROPTIONS ;

    GO

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply