What are the challenges you face when working across database platforms? Take the survey
Options

Missing syscomments entry

pkoebbepkoebbe Posts: 2
edited November 18, 2006 10:30AM in SQL Compare Previous Versions
Running SQL Compare 3, I get:
Missing syscomments entry. Please check your database

What exactly does this mean (other than there is not a record in syscomments for this object) and what is the easiest way to fix it?

Thanks,
Phillip

Comments

  • Options
    Hi Phillip,

    I haven't seen this before and I suspect it's either because you're attempting to use SQL Compare version 3 against SQL 2005, or there is indeed something wrong with the database. Syscomments is where a lot of the DDL for the database is stored. If the table is missing or damaged, SQL Compare would not be able to get eny schema information out of the database.
Sign In or Register to comment.