SQL server Script

• jesuseun

  SSC Enthusiast

  Points: 141

  More actions

  August 4, 2005 at 4:26 am

  #165113

  I need an SQL Server Script that would capture all the details about all the database on a particular server:

  Information like database name ,size,tables,indexes and users (plus more if possible).

  I would be very grateful if you can send me or point me to one ASAP.

  Cheers

  Jesuseun

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  August 4, 2005 at 1:34 pm

  #579809

  There are plenty of pieces and parts in the scripts section of this site, but what you are looking for is not there in a single script.

  http://www.sqlservercentral.com/Scripts/listscripts.asp?categorynm=Maintenance%20and%20Management%20&categoryid=1