Migrating SQL Server 2000 to 2008/14 - Stored procedures compatibility?
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