How to determine if you code is supported in SQL 2008 when moving from SQL 2005 / 2000

How to determine if you code is supported in SQL 2008 when moving from SQL 2005 / 2000.

I know I’m a little late to the party, but if you are upgrading a server from SQL 2005 / 2000 to SQL 2008 and need to determine what features you are using that are not supported or are deprecated in SQL 2008, the following tools can give you starting point as to what you need to change and where.

1.       Microsoft SQL Server 2008 Upgrade Advisor: This tool will analyze the different features and instances that you currently have running on SQL 2005 / 2000 and identify problems or changes that will have to be made before your upgrade. Learn about it here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en

2.       SQL Profiler: You can use SQL’s built in profiler to capture statements and procedures that trigger the Deprecation Announcement or Deprecation Final Support events. To see these events, you must check the Show All Events check box and look under Deprecation. Run this against the server you want to upgrade and it will return the application and, depending on what other events you are capturing, the offending code.