In SQL Server 7/2K, if sp_spaceused is dropped and re-created, using it without any parameters in any database to obtain the size of the database, always reports the size of the master database.
Q1 Any ideas ???
A1 Yes, make certain you have a full correct script, your server is service packed, and that you have appropriatly changed the DB context. (The behavior could not be duplicated on an up to date instance using the procedure named sp_spaceusedTest, attached.) What are the results of the following: