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

Qualify Object names with .dbo.[viewname]

PhilParkinPhilParkin Posts: 6
edited February 23, 2012 1:07PM in SQL Prompt Previous Versions
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.

Comments

  • Options
    meklemblmeklembl Posts: 107 Bronze 2
    Following this message because I am seeing the same result.
    Larry M
    Cleveland, OH USA
  • Options
    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.
    Systems Software Engineer

    Redgate Software

Sign In or Register to comment.