Appreciate that this may seem like a silly question, but you are running the procedure on the SQL 2000 server not the new server

Also you are running this version of sp_help_revlogin http://support.microsoft.com/kb/246133, not this one http://support.microsoft.com/kb/918992

There is a version for SQL 7 and 2000, and one for 2005 onwards.