Sql Prompt not Qualifying object names
KevinLarkan
Posts: 1 New member
in SQL Prompt
Hi
My version of SQL prompt is 10.11.7.27287
My version of SSMS is 15.0.18410.0
My Sql server version is 14.0.3401.7 (X64)
I have been using Sql Prompt for a number of years now and have always enjoyed the Qualify Object Names feature. I recently had to reload my operating system and therefore all my production tools, including Sql Prompt. The Qualify Object Names feature no longer works. I have tried very simple queries and also complex queries, the screen appears to flash but no object names are aliased. I have tried specifying the alias with the "AS" keyword and also without.
So far ALL other features of the product work just fine. I have "Enabled Verbose Logging" but nothing of interest is found in the logs.
Please can you assist?
Regards
Kevin
(+27) 82 2590562
My version of SQL prompt is 10.11.7.27287
My version of SSMS is 15.0.18410.0
My Sql server version is 14.0.3401.7 (X64)
I have been using Sql Prompt for a number of years now and have always enjoyed the Qualify Object Names feature. I recently had to reload my operating system and therefore all my production tools, including Sql Prompt. The Qualify Object Names feature no longer works. I have tried very simple queries and also complex queries, the screen appears to flash but no object names are aliased. I have tried specifying the alias with the "AS" keyword and also without.
So far ALL other features of the product work just fine. I have "Enabled Verbose Logging" but nothing of interest is found in the logs.
Please can you assist?
Regards
Kevin
(+27) 82 2590562
Tagged:
Answers
What options are selected in your SQL Prompt > Options > Qualification?
Does selecting all these then restarting SSMS enable Qualifying objects for you?