DBCC Commands

• Santhosh Kumar

  Right there with Babe

  Points: 766

  More actions

  October 10, 2005 at 1:34 pm

  #110216

  Im trying to execute a DBCC command on a table owned by a non dbo user.. I have having sa rights. even then when I try to execute the command as

  dbcc showcontig (<tablename&gt

  I am getting error saying that the object does not exists. when I try to qualify like

   

  dbcc showcontig (objectowner.tablename)

  I am getting incorrect syntax error. any clues why?

   

   

  with smiles

  santhosh

   

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  October 10, 2005 at 2:14 pm

  #596370

  Input for is a string

  if you do dbcc showcontig (objectowner.tablename) you get an error. But if you do

  dbcc showcontig ('objectowner.tablename') it should work.

  or you can do

  declare @TableID int

  select @TableID = (OBJECT_ID('objectowner.tablename'))

  dbcc showcontig (@TableID)

  Please look up dbcc showcontig in books online

• Steve Riley-205554

  SSC Enthusiast

  Points: 127

  More actions

  October 11, 2005 at 9:21 am

  #596559

  Santhosh,

  If I understand, all you need to do is enclose the owner and table name in single quotes.

  DBCC SHOWCONTIG('bill.tablename')