How can we help you today? How can we help you today?

Find invalid objects: false positive on sp_upgraddiagrams

Using SSMS 2008 R2, I have added database diagrams to a SQL 2008 database. This invoked some scripts that added new system objects to my database to support the diagrams.

Now, SQL Prompt (5.1.16.35) labels one of these new sprocs as invalid:
Object name: dbo.sp_upgraddiagrams
Reason invalid: Invalid object name 'dbo.dtproperties'.

Should SQL Prompt ignore this particular object?
weswinkler
0

Comments

1 comment

Sort by
  • Chris Auckland
    Thanks for your post.

    I've logged this as a bug with SQL Prompt 5 (SP-4021), but it's curious why it marks the object as invalid.

    It marks the object as invalid because it references dbo.[dtproperties], which doesn't seem to exist anywhere in the database. i.e. unlike all the other system and user objects, dbo.[dtproperties] isn't listed in sysobjects.
    Chris Auckland
    0

Add comment

Please sign in to leave a comment.