If you are migrating the database from SQL Server 2000 to 2005, there should ot be any issue as such as SQL Server 2005 is backward compatible and all the statements, functions and other database objects and syntax of SQL Server 2000 works fine in SQL Server 2005. In case of conflict, during migration it will show the alerts. However for double checking, you can run through the test cases that are meant for sections, that have database transactions.