I have a database on SQL Server 2000 (no, I can't upgrade right now) where I'm trying to run sp_spaceused on each table.
I'm getting the messages below. Any given table may have any, all, or none of the messages.
Server: Msg 15064, Level 11, State 1, Procedure sp_spaceused, Line 96
PRIMARY KEY and UNIQUE KEY constraints do not have space allocated.
Server: Msg 15275, Level 16, State 1, Procedure sp_spaceused, Line 101
FOREIGN KEY constraints do not have space allocated.
Server: Msg 15235, Level 16, State 1, Procedure sp_spaceused, Line 91
Views do not have space allocated.
I've Google'd and Bing'd high and low, but have not found any info of use.
FWIW, I can run sp_spaceused without these messages against tables in another database on the same server.
Has any one else ever seen this?
UPDATE
I did run DBCC CHECKDB and it did not find any problems.
The table sizes are returned by sp_spaceused even when the messages appear.
After reading http://msdn.microsoft.com/en-us/library/aa224774(v=sql.80).aspx, I'm inclined to believe these are just notification messages, not error messages.
I was concerned because I had never seen these particular messages before and I've had some other problems with this database recently. Everything seems to be working ok, so I will just keep an eye on it for now.
DBCC CHECKDB? – Martin Smith Sep 26 '12 at 16:12