Hi All,

We are migrating sql server Stored Procedures from 2005 to 2012.

We are facing some conflicts(Keyword changes) while migrating into 2012. We are executing each and every stored procedure and

finding some keyword changes.We have nearly 2000 stored procedures. It is a time consuming process.

What are the best way to find out the changes in 2012

Does anyone have script(Sql server) to find out/what are the changes need to be change in 2012.

Thanks in advance...

I believe the only breaking change in T-SQL (2012) is the syntax of raiserror. Are you getting any error other than this? 

 

I would suggest you to first run SQL server 2012 upgrade advisor it would point to ALL BREAKING CHANGES. You can learn more about breaking changes in SQl Server 2012