Home Forums SQL Server 7,2000 T-SQL SQL 2000 query to populate temp table using EXEC sp_spaceused RE: SQL 2000 query to populate temp table using EXEC sp_spaceused

  • This script provides a good example of what you are trying to do.

    Script is used to analyze table space usage using the output from the sp_spaceused stored procedure

    Works with SQL 7.0, 2000, 2005, 2008, 2008 R2. May work with 2012, but I havn't tested it there.

    Script to analyze table space usage

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762