Move stored procs from 2000 to 2005

It's easy to move the tables, but how do you transfer stored procs and triggers?A few ways you can do this.

If you want to move a whole database, you can either backup the database from SQL 2000 and restore to 2005, or detach\reattach.

If you want to be more selective, you can use SQL Enterprise Manager on 2000 to script out the specific stored procedures\triggers to a script file, then execute the script on SQL 2005 using SQL Management Studio.

Jeff.