As part of a side-by-side migration from SQL Server 2000 to SQL Server 2008R2, I need to find all the stored procedures and triggers that are on SQL 2000 and/or that are on each of the databases. I do not know if I should worry about the stored procedures and triggers in the system databases.
Please let me know how I can do that, and how I can migrate them to SQL Server 2008R2. This migration will be taken place sometime in the future, but I want to start getting ready for this.
At the moment, all I can do is test all the parts of the migration. Therefore, I want to learn how to do this part, the migration of the stored procedures and triggers, so that I can start testing it.