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

Qualify Object Names with .. notation

PhilParkinPhilParkin Posts: 6
edited February 23, 2012 7:41AM in SQL Prompt Previous Versions
The following query is perfectly valid:
select top 10 * 
from master..spt_values

But running Qualify Object Names (SQL Prompt 5.2.2.1) on it results in an error:
"The object ... could not be found in the database"

I was expecting master..spt_values to become master.dbo.spt_values.

Comments

Sign In or Register to comment.