Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

SQL Server - Finding deprecated features that currently we used

Jan 12 2012 12:59AM by Hardik Doshi   

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'
FROM sys.dm_os_performance_counters
WHERE object_name = 'SQLServer:Deprecated Features'
and cntr_value > 0
Read More..   [41 clicks]

Published under: SQL Server Tips ·  ·  ·  · 

Hardik Doshi
20 · 9% · 2839
23
 
4
 
21
 
0
Incorrect
 
0
Interesting
 
0
Forgotten


Submit

3  Comments  

  • Thanks...I think the > sign got changed in your query.

    commented on Feb 1 2012 12:22PM
    Jason Yousef
    152 · 1% · 319

  • Fixed it :-)

    commented on Feb 2 2012 4:15AM
    Jacob Sebastian
    1 · 100% · 32002

  • Thanks Jacob

    commented on Feb 2 2012 4:22AM
    Hardik Doshi
    20 · 9% · 2839

Your Comment
Sign Up or Login to post a comment.
"SQL Server - Finding deprecated features that currently we used" rated 5 out of 5 by 23 readers
SQL Server - Finding deprecated features that currently we used , 5.0 out of 5 based on 23 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]