What are the issues related to migrating stored procedures and user-defined functions from SQL 2000 to SQL 2005? Is there a good reference on this to which someone could point me?

It looks like embedded comments prefixed with -- will no longer work in SQL 2005. Also, it looks like there may be some additional issues related to referencing objects (dbo. prefixes, etc). I'm trying to support someone remotely who's taken over some of my code on a secure network.

Thx in advance.