Posts
Sort by recent activity
BUG: "Format SQL" introduces syntax errors
Hi all,The code below, though ill-formatted, is correct and works without error in SQL Server 2022:
SELECT frsx.ProductKey,<br> SUM (CAST (frsx.ShipDateKey AS bi...
IGNORE NULLS and RESPECT NULLS not recognized for LAG and LEAD
Hey all!Today I noticed that SQL Prompt seems to be blissfully unaware of the new IGNORE NULLS and RESPECT NULLS optional keywords for the LAG and LEAD functions. However, when used with FIRST_VALU...
"Format SQL" fails on query hint
Don't know if this is due to a recent upgrade, or due to a specific query. But here are the steps to reproduce.(My configuration: SSMS 19.2.56.2; SQL Prompt 10.14.3.4664; SQL Server 2022, RTM-CU8-G...
SQLPrompt doesn't recognize "rollup" as reserved word
I have set SQL Prompt to automatically remove those [silly] and [[[useless]] [brackets]]]] where possible. Great with inherited code...However, I just ran into a situation where this causes an erro...
Breaking bug in SQL Prompt
SELECTHi!I just ran into a dangerous bug in SQL Prompt, where it changes my code instead of merely reformatting it. I am running 9.5.12.10845, which I think is the latest build. The repro code belo...
How to find out why SQLMonitor cannot access (some) data
One of my clients uses (on my suggestion) SQLMonitor to monitor their production databases. On one of the servers (incidentally the server that hosts the SQLMonitor database itself) I always see a ...
Don't check Agent status for Express Edition
Whenever I add a server to the monitoring that is Express Edition, I get alerted that the SQL Agent service is not running.Well d'uh. It's Express Edition. The Agent service cannot run on it.Instea...