DBCC SHOWCONTIG is giving error for tables in different schema

• Knowledge Hunter

  SSCrazy

  Points: 2287

  More actions

  August 10, 2011 at 1:32 am

  #245967

  Hello All

  When I am using the following query:

  DBCC SHOWCONTIG (HumanResources.department)

  I am getting the following error:

  Msg 102, Level 15, State 1, Line 1

  Incorrect syntax near '.'.

  When I use:

  DBCC SHOWCONTIG (department)

  it gives:

  Msg 233, Level 20, State 0, Line 0

  A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

  Have logged in with Admin credential and the defrault schema for it is DBO.

  Please let me know how to execute the query by using schema.

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  August 10, 2011 at 1:53 am

  #1366412

  You have to put double-quotes around the table name.

  DBCC SHOWCONTIG ("HumanResources.Employee");

  Or even better since DBCC SHOWCONTIG is deprecated, use sys.dm_db_index_physical_stats

  SELECT * FROM sys.dm_db_index_physical_stats(db_id(), object_id('HumanResources.Employee'), NULL, NULL , 'LIMITED');

  [font="Verdana"]Markus Bohse[/font]

• Knowledge Hunter

  SSCrazy

  Points: 2287

  More actions

  August 10, 2011 at 11:45 am

  #1366780

  Thanks Markus for your help