Documenting SQL Server properties

• waycomgroup

  Grasshopper

  Points: 19

  More actions

  June 28, 2010 at 4:16 pm

  #145749

  I need to document all the databases and tables in our SQL Server. This must include the information on the general properties tab of each database i.e. Name, Status, Date Created, Size etc. Is there a simple way to do this?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 29, 2010 at 1:47 am

  #1186206

  Look into INFORMATION_SCHEMA views: they hold information on the whole database structure.

  -- Gianluca Sartori