This calls sp_SpaceUsed for each table in a database and accumulates the data in a temp table. Output the data to a file or table to monitor the database.
Source: Sql Server. Get space used (sp_SpaceUsed) for all tables in database - Author Nigel Rivett
No comments:
Post a Comment