My junior DBA got this error when she wanted to find out the space used by primary key.
Msg 15234, Level 16, State 1, Procedure sp_spaceused, Line 69
Objects of this type have no space allocated.
Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62
The object ‘objectname’ does not exist in database ‘dbname’ or is invalid for this operation.
RESOLUTION: Use the sp_spaceused on table instead of primary key. When you run sp_spaceused ‘tablename’ then index_size value gives the size of the index.
INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.
- SQL Server DBA “Interview Questions And Answers”
- SQL Azure Interview Questions and Answers Part – 1
- SQL Azure Interview Questions and Answers Part – 2
- Powershell Interview Questions and Answers
Online MSSQL Classes @ http://tuitionaffordable.webstarts.com