How do I know which deprecated features I’m using?
To find out, run the following query:
SELECT instance_name AS 'Deprecated Feature', cntr_value AS 'Times Used'
WHERE object_name = 'SQLServer:Deprecated Features'
and cntr_value > 0
SQL Server Tips · · · ·
Thanks...I think the > sign got changed in your query.
Fixed it :-)