Posts
Sort by recent activity
Query Formatting - Error Laying Out SQL message
Hello Redgate. Using SQL Prompt V7.3.0.775, when I attempt to reformat the following code, I get an 'Error laying out SQL' dialog box.SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
FROM (VAL...
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 ...
Qualify Object Names with .. notation
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 foun...