SQL 2000 query to populate temp table using EXEC sp

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » T-SQL » SQL 2000 query to populate temp table using...

SQL 2000 query to populate temp table using EXEC sp_spaceused

Rate Topic

Display Mode

Topic Options

Author

Message

melloman

Posted Wednesday, February 13, 2013 10:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 6:58 AM
Points: 3, Visits: 15

Hi,

I was wondering if you could help me.

I was wondering how to populate the output of SQL2000 sp_spaceused into a temp table (#t). But my flowing T-SQL query fails:

CREATE TABLE #t
(database_name VARCHAR(20), database_size VARCHAR(18), [unallocated space] VARCHAR(18),
reserved VARCHAR(18),data VARCHAR(18), index_size VARCHAR(18), unused VARCHAR(18)
)

select * from #t
--EXEC sp_spaceused

INSERT INTO #t (database_name, database_size, [unallocated space], reserved, data, index_size,unused) EXEC sp_spaceused
--drop table #t

error mgs on running I get:
Server: Msg 213, Level 16, State 7, Procedure sp_spaceused, Line 148
Insert Error: Column name or number of supplied values does not match table definition.

Can anyone help?

Post #1419653

Michael Valentine Jones

Posted Wednesday, February 13, 2013 11:29 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:01 PM
Points: 2,944, Visits: 10,504

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

Post #1419668

« Prev Topic | Next Topic »

Permissions