SQL Deprecated Features

• ShuaibV

  SSCrazy

  Points: 2001

  More actions

  March 16, 2011 at 12:53 pm

  #389065

  Is there any easy way / tool to determine the usage of the SQL deprecated features both in SQL and .NET Applications?

  Thanks

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  March 16, 2011 at 1:06 pm

  #1299606

  Try this T-SQL

  SELECT * FROM sys.dm_os_performance_counters WHERE object_name LIKE ('%deprecated%')

  and/or read this:

  http://msdn.microsoft.com/en-us/library/ms186265.aspx

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]