script for finding the database properties

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  July 17, 2009 at 4:23 am

  #155976

  can any one send me the script for finding all the databases properties in sql 2000/2005

  thanks

• NicHopper

  SSCrazy Eights

  Points: 9090

  More actions

  July 17, 2009 at 4:26 am

  #1026078

  Hi,

  This will work in SQL 2005 for getting the db properties;

  SELECT * FROM Sys.databases

  Hope this helps.

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