Results 1 to 9 of 9
  1. #1
    Join Date
    Aug 2010
    Posts
    25

    Unanswered: Schema Name is changing automatically

    Table's Schema Name is changing automatically..


    Missing a letter in the schema name & it's showing table doesn't exist when i run dbccshowcontig.error 2501

    any help is appreciated

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Are you running DDL code to create the table?

    We really need more information to help you.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Aug 2010
    Posts
    25
    Quote Originally Posted by blindman View Post
    Are you running DDL code to create the table?

    We really need more information to help you.
    no.already existed table ........previously job was successful,now job failed due to object doesn't exist.

    error 2501

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Changing schema names is not something that SQL Server will do spontaneously. Ask around, and find out who in your group has changed it to the wrong thing.

  5. #5
    Join Date
    Aug 2010
    Posts
    25

    sompsed MRS

    one time it is showing wrong schema name(missing one letter in the schema name)

    if i refresh the database it's showing correct schema name


    rowcount also differing in this scenarios

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Sounds like you have two tables with similar names, then. Just different rowcounts. "Refreshing the database" (really refreshing SSMS) will re-order the list of tables alphabetically by schema name, then table name.

  7. #7
    Join Date
    Aug 2010
    Posts
    25
    i'm running the job with dbshowcontig ,job keep on failing due to this table doesn't exist(previously ran successfully)


    Cannot find a table or object with the name "Servername\sqlsrvr.XYZ(table name)".


    Check the system catalog. [SQLSTATE 42S02] (Error 2501) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0) [SQLSTATE 01000] (Error 0). The step failed.

  8. #8
    Join Date
    Aug 2010
    Posts
    25
    Any help is appreciated.

    Thanks

  9. #9
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    You need to help us, before we can help you. If you went to a doctor, and simply said "it hurts", the doctor would likely kick you out as a troublemaker. If you went to the doctor, and said "It hurts when I do this", and show the doctor what makes the pain, you may come away with a treatment.

    In short, post the code that generates this error. And no, I do not mean
    Code:
    dbcc showcontig('tablethatobviouslydoesnotexist')
    As I have said before, you should check the spelling of all of the parts involved. This includes the actual table name, and schema, as well as the table name and schema you are supplying to dbcc showcontig.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •