The new DMF to get the buffer only worked after I applied the lasted SQL 2016 CU. EF or ORM products could include such a metric with ease so that the dev can get metrics with no work.) Time for RegEx? (Remove the metric message stuff if you want to try this.

I’m not doing much for my poor attempt at the syntax check, so the overhead is too small to measure using my metric code. METRIC : elapsed 0 ms, cpu 0 ms, logical 0 pgs, reads 0 pgs, writes 0 pgs Msg 50000, Level 16, State 1, Procedure CheckSyntax, Line 25 ĭeleting or updating while going TOP-less with no WHERE in mind is a bad idea! RAISERROR(‘Deleting or updating while going TOP-less with no WHERE in mind is a bad idea!’, 16, 1) WITH NOWAIT ĮXECUTE _request_metric_msg ‘check buffer’, - message How about parsing the input buffer in the trigger?ĭECLARE binary(32) = _get_request_metric() - 1st measurementĭECLARE varchar(max) = (SELECT REPLACE(REPLACE(event_info, char(13), ‘ ‘), char(10), ‘ ‘) FROM sys.dm_exec_input_buffer 0))ĭECLARE bit = CASE WHEN 7) = ‘DELETE ‘ OR CHARINDEX(‘ DELETE ‘, > 0 THEN 1 ELSE 0 ENDĭECLARE bit = CASE WHEN 7) = ‘UPDATE ‘ OR CHARINDEX(‘ UPDATE ‘, > 0 THEN 1 ELSE 0 ENDĭECLARE bit = CASE WHEN 6) = ‘WHERE ‘ OR CHARINDEX(‘ WHERE ‘, > 0 THEN 1 ELSE 0 ENDĭECLARE bit = CASE WHEN CHARINDEX(‘ TOP ‘, > 0 THEN 1 ELSE 0 ENDĭECLARE binary(32) = _get_request_metric() - 2nd measurementĭECLARE binary(32) = NULL) - difference

Sql prompt where clause warning