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

Qualify Object names with .dbo.[viewname]

Similar to my previous post...

The following query is valid:
select top 10 *
from    msdb.dbo.sysjobs_view

But running

Qualify Object Names on it results in an error:
The object ... could not be found in the database.

Am I misusing this feature?

Thanks.
PhilParkin
0

Comments

2 comments

Sort by
  • meklembl
    Following this message because I am seeing the same result.
    meklembl
    0
  • James B
    Thanks for posting. I see the same thing here. I've found a bug where the Qualify Object Names process doesn't work correctly on system objects, and I guess that's related to what you're seeing. The bug reference is SP-3635 but I don't have any update on when it's likely to be looked at.

    I've linked back to this forum post in any case, so we can let you know if and when it's fixed.
    James B
    0

Add comment

Please sign in to leave a comment.