Post reply

Run ShowContig cmd on Non DBO tables don't work

  • July 31, 2009 at 4:18 pm

    #132579

    On SQL Server 2000 server I have server role 'sysadmin'.

    I have 2 databases, 1 database has tables with the regular 'dbo.tablename', the other database has tables with 'devowner.tablename'.

    When I run the following DBCC command, it works for the dbo owned tables, but not for the 'devowner' tables.

    DBCC SHOWCONTIG ('dbo.aliasid') -- shows info

    DBCC SHOWCONTIG (117573545) -- using object id # also works

    DBCC SHOWCONTIG ('devowner.aliasid') -- no info

    it only returns the following message......

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    Since I have the 'sysadmin' server role, I thought this should work. Does anyone know the reason why this is happening?

  • July 31, 2009 at 9:27 pm

    #1033264

    Do the non-dbo tables show up for the following?

    DBCC SHOWCONTIG WITH TABLERESULTS, ALL_INDEXES

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply