http://blogs.technet.com/andrew/archive/2008/03/25/sql-server-compatibility-mode.aspxI drew the short straw at the 2008 Launch event last week in Birmingham; speak for one hour on upgrading SQL Server.&#160; I found this very difficult because on the one hand you can usually just do the upgrade, once you have done all the pre-requisiteen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.technet.com/andrew/archive/2008/03/25/sql-server-compatibility-mode.aspx#3143964Wed, 29 Oct 2008 13:09:57 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3143964Michael Falconer<p>You mention in your article 'The reason I do like compatibility mode is that while it is on you can then set up profiler to watch for any events that use this feature.'. Can you provide any more information on this? We've a number of SQL 2000 databases we want to migrate but we will be running them in compatability mode to start with.</p> <p>I see there is a deprecation section in the events available to be tracked in profiler.</p>