>Hi,
>
>We need to upgrade a SQL 2000 database to SQL 2008 R2. This means that we must check code in a whole lot of stored procedures, aproximatetly 1000.
>Does anyone know of a third party product that can check code from different sources and release a report on sentences that must be changed in order to upgrade properly?
>
>Thanks,
>
>Daniel


Hi Daniel,

Have you tried upgrade Advisor tool?

http://msdn.microsoft.com/en-us/library/ms144256(v=sql.105).aspx