SQL Server 2005-2008 Compatibility Check A few databases were recently migrated from SQL Server 2005 to SQL Server 2008, and I have to check if all the stored procedures, and triggers still work well. With 'checking', I mean that I should guarantee that they are compilable and executable.

There are many stored procedures and triggers to check. To do it manually, I would need maybe 1 month. So, I want to take another approach.

What kind of checking procedure would you recommend me, so that I can say surely that the stored procedures and triggers will also work in SQL Server 2008?

Thanks
Is the 2005 instance still your production instance? If so, you could use a server side trace to capture a workload and replay it on the 2008 instance. You should try to capture your normal workloads. You have to decided what is normal in your system. This wouldn't guarantee that all stored procs will work, but you day to day activity should be fine.

As far as compatibility levels please review the BOL link:
http://msdn.microsoft.com/en-us/library/bb510680.aspx