SQL Server Performance

DataBase Space Management

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by y.koteswarrao, Nov 1, 2008.

  1. y.koteswarrao New Member

    Hi All,
    How to trace the Database space of all database rather than single database by using sp_spaceused?
    Koteswar Rao.Y
  2. madhuottapalam New Member

    One simple solution which works in all the versions would beEXEC SP_MSFOREACHDB "use ? ; exec sp_spaceused"Madhu

Share This Page