Migrating SQL Server 2000 to 2008/14 - Stored procedures compatibility? I am planning migration from old SQL server 2000 db to 2014 (through 2008 extra step). I Wonder if stored procedures will work with no tweaks or arrangements are required
You should check breaking changes.

you can use upgrade advisor or 

dbatools - Test-DbaMigrationConstraint 


  This function only validate SQL Server 2008 versions or higher.


I have written an extensive list of things you should check when you migrate from 2000 to higher versions