Objects of this type have no space allocated

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.

  1. SQL Server DBA “Interview Questions And Answers”
  2. SQL Azure Interview Questions and Answers Part – 1
  3. SQL Azure Interview Questions and Answers Part – 2
  4. Powershell Interview Questions and Answers

Regards,
Online MSSQL Classes @ http://tuitionaffordable.webstarts.com

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s