Find discontinued features

• 
  I'd take a look at https://docs.microsoft.com/en-us/sql/database-engine/deprecated-database-engine-features-in-sql-server-2016, whilst there's nothing query specific it does contain all of the sprocs, functions, options etc that are being deprecated/removed, so you might be able to narrow down what you need from it.
  

  Russell D March 27, 2018 14:38

  - 0 +
• 
  I need a tool, that analyzes a production trace file and finds the discontinued features of SQL Server 2016.

  Alex1 March 28, 2018 06:18

  - 0 +
• 
  Oh right you want a tool to do it for you. Well it's built into SQL Server. Use SQL Server Profiler to issue Deprecated Announcements, and then profile your code. You'll get Deprecated Announcements showing up in the SQL Logs. It'll require some (minimal) legwork though.
  
  Oh and the SQL Profiler has ironically been deprecated, but its in SQL Server 2016 (its final version).

  Russell D March 28, 2018 07:35

  - 0 +
• 
  there is no tool to find discontinued features of SQL server 2008 R2, you have to manually do it, use SQL profiler to issue deprecated announcements. 

  amalia_tracy March 19, 2019 07:33

  - 0 +

Add comment

Please sign in to leave a comment.