Post reply

Cannot drop SQL table

  • December 5, 2011 at 8:22 am

    #251396

    I have SQL 2008 Sp1. There s a table in a database that I cannot drop.

    There is a schema corruption on the table. I cannot alter, drop, rename, add rows. Even the properties show me nothing just says "possible schema corruption" every where.

    This table has 0 rows so I can get rid of this table and then again create the table from test. but first need to remove it. Any ideas on this?

  • December 5, 2011 at 8:24 am

    #1416725

    Sounds like you have a lot more serious issues. What does this return?

    DBCC CHECKDB ('db name') WITH NO_INFOMSGS, ALL_ERRORMSGS

  • December 5, 2011 at 8:42 am

    #1416737

    DBCC does not return anything and also nothing from DBCC CheckCatalog.

    I know there is a schema corruption and need to drop and re-create the table.

  • December 5, 2011 at 8:44 am

    #1416740

    Was this db upgraded from 2000?

    If there's corruption, checkdb will return an error, no doubt about that one.

  • December 5, 2011 at 8:58 am

    #1416748

    Sorry my bad :

    when running DBCC CHECKDB i get no errors

    but when running the

    DBCC CHECKDB (DB_name) WITH NO_INFOMSGS, ALL_ERRORMSGS get

    A severe error occurred on the current command. The results, if any, should be discarded.

  • December 5, 2011 at 8:59 am

    #1416751

    No there was no upgrade done. May be an un-expected Server shutdown.

  • December 5, 2011 at 9:00 am

    #1416753

    And the exact error is?

  • December 5, 2011 at 9:09 am

    #1416762

    When I run

    DBCC CHECKDB (DB_name) WITH NO_INFOMSGS, ALL_ERRORMSGS

    i get :

    A severe error occurred on the current command. The results, if any, should be discarded.

    When I try to rename, drop or alter table I get :

    Possible schema corruption. Run DBCC Checkcatalog

    when I run DBCC CHECKCATALOG

    i get no errors

  • December 5, 2011 at 9:14 am

    #1416771

    Anything more useful in the logs?

    got a backup you can restore from?

    Calling in reenforcements.

  • December 5, 2011 at 9:39 am

    #1416800

    I already restored but same issue.

  • December 5, 2011 at 9:42 am

    #1416805

    And no other backups I guess?

    Is this a prod server?

  • December 5, 2011 at 11:20 am

    #1416909

    If you have no clean backups... (and if not, there's something seriously wrong with your maintenance routine)

    Script all objects, export all data, recreate the database

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 5, 2011 at 11:21 am

    #1416910

    @Gail, Tx for dropping in, I was hoping for another of your magik solution 😉

  • December 6, 2011 at 8:22 am

    #1417411

    any ideas???

  • December 6, 2011 at 8:23 am

    #1417413

    Yes.

    GilaMonster (12/5/2011)

    If you have no clean backups... (and if not, there's something seriously wrong with your maintenance routine)

    Script all objects, export all data, recreate the database

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 15 posts - 1 through 15 (of 17 total)

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