SQL Server Profiler Identifying Deprecated Features

Sql Server 2005 has events in profiler that can be captured to identify the code with deprecated features.

Following steps are required inorder to have the required information logged in through profiler.

• Navigate to Start >All Programs >Microsoft SQL Server 2005 >Performance Tools >SQL Server Profiler. OR
• Navigate to StartMenu>Run>(type) profiler90
• Start a New Trace after authenticating to Sql server that you wish to profile.
• In trace properties at general tab select save information in file or table.
• In order to review all events, enable the check box for 'Show all events' and 'Show all columns' on the bottom right of the screen

• Then navigate to the 'Deprecation' heading and enable the 'Deprecation Announcement' and 'Deprecation Final Support' events

• Press RUN
• Analyze the results which says 'Deprecation Announcement'.