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

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

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.

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

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.

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.

Any help is appreciated.

Thanks

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
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.