Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
1  
Have you checked the database for corruption with DBCC CHECKDB? –  Martin Smith Sep 26 '12 at 16:12
    
Going for the obvious, I would think these are simple warning messages. Does sp_spaceused return the space used by the table, or just this message and nothing else? –  Max Vernon Sep 26 '12 at 19:26
1  
have you read this page about indexed views - it mentions your msg number 15235 - msdn.microsoft.com/en-us/library/aa224774(v=sql.80).aspx –  Max Vernon Sep 26 '12 at 19:30
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.