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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?


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, 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
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
have you read this page about indexed views - it mentions your msg number 15235 - – Max Vernon Sep 26 '12 at 19:30

Your Answer


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

Browse other questions tagged or ask your own question.