Post reply

Check Catalog Msg 3854...

  • January 24, 2011 at 4:17 pm

    #1277522

    moosamca (1/24/2011)

    Hi,

    Did you tried DBCC CHECKTable with Repair_rebuild?

    Regards

    Moosa

    It's great that you're enthusiastic - but please don't post advice when you don't know what you're talking about. You cannot repair CHECKCATALOG errors.

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

  • January 25, 2011 at 12:14 pm

    #1278092

    Thanks for all of your responses and insights - really appreciated. The only solution to this issue is the Script, Export, and Recreate fix as recommended by Gail and Paul and I began the process in dev.

    Thanks again for all your help.

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

Viewing 2 posts - 16 through 17 (of 17 total)

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