Home Forums SQL Server 2005 Administering QUERY: GET SPACE USED/FREE in All Databases RE: QUERY: GET SPACE USED/FREE in All Databases

  • March 6, 2009 at 11:28 am

    #955142

    There is an undocumented system procedure that executes any T-SQL query in all databases.

    EXECUTE sp_MSforeachdb 'EXECUTE sp_spaceused'

    --Ramesh