Verify Level 100 Compatibility of Databases

I switched from SQL Server 2005 to SQL Server 2008 already. I only found out about the Upgrade Advisor after I had made the switch and the Upgrade Advisor doesn't seem to work with SQL Server 2008. My databases are still set with a compatibility of 90. Is there a simple test I can run to see if it's okay to switch to level 100?
LVL 14
quizwedgeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Yes, you can run a profiler trace and capture the Deprecated events to decide whether you are good enough to change your Compatibility level to 100. Use the below link to run Profiler trace to capture so.
http://www.mssqltips.com/sqlservertip/1370/identifying-deprecated-sql-server-code-with-profiler/

Run the profiler trace for 2 days or max a week and check for commands involved. If you don't have any, then you can safely switch Compatibility level to 100.
0
 
quizwedgeAuthor Commented:
Excellent. Thanks!
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Welcome..
And another note, make sure you do all kind of transactions or events from your application so that you will capture and verify all events in your database to decide it completely.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.