Post reply

Database Autoclose

  • October 23, 2009 at 1:45 am

    #103843

    Hello all,

    I need to find where the database autoclose property is stored in sql 2000. I can find the same in 2005 by querying sys.databases table but having problems finding in 2000.

    I need to query some table to find this and not via GUI.


    Pradeep Singh

  • October 23, 2009 at 2:21 am

    #1069845

    Thanks..

    i got the answer.

    I can do it by using

    exec sp_dboption 'pubs'


    Pradeep Singh

  • October 23, 2009 at 3:37 am

    #1069878

    You can do it, by query too...

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

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