default settings of a database

• pmadhavapeddi22

  SSCertifiable

  Points: 5306

  More actions

  July 13, 2009 at 6:28 am

  #223581

  Hi,

  I want to get the default setting of a particular datbase whihc

  we get through enterprise manager by right clicking mouse on properties

  But i want the results from database from the tables

  May be the same info is stored in any system tables in master database

  Please help me immdtly

  Thanks

• NicHopper

  SSCrazy Eights

  Points: 9090

  More actions

  July 13, 2009 at 6:38 am

  #1023826

  Hi,

  You could query the Sys.databases table, this should give you all the information you need regarding your database.

  Hope this helps,

  Jackal

  Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

• pmadhavapeddi22

  SSCertifiable

  Points: 5306

  More actions

  July 13, 2009 at 7:25 am

  #1023865

  thanks, that helped me, i tried getting information from sysdatabases