Post reply

To find the set option currently set for a database

  • October 25, 2005 at 12:35 am

    #67586

    Hi Gurus,

    Can anybody tell me how to find out the current set options for a database. I think it set for every session. When a job is executed what are the settings that it applies by default. What are the operations that enables session settings

    Any pointers welcome

    thanks in advance

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • October 25, 2005 at 1:16 am

    #599724

    Well, I am not quite sure which options you are looking for.

    - sp_configure will show you which options are set for the server

    - the 'user options' option can be used to view and/or set a global default for new sessions

    - DBCC USEROPTIONS will show you which options are set for the current connection.

    - sp_dboption 'foo' will show you which options are set in database foo

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • October 28, 2005 at 12:07 am

    #600805

    Hi Chris,

    thanks you. DBCC USEROPTIONS is what I was looking for.

    Great


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

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

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