Transfer Logins - Plz help

[kpsreenath]

Hi all
In the process of migration of a database from one SQL 2000 server to another, I am transfering the logins using the microsoft documented script

http://support.microsoft.com/kb/246133/

When i am executing the script on the source server, I am getting the following error.

Server: Msg 195, Level 15, State 10, Procedure sp_help_revlogin, Line 52
'LOGINPROPERTY' is not a recognized function name.

In all the past migrations , I have used this without any issues, but not sure what have changed.

Or am i doing something really stupid.
Can you guys pls execute this in your server and see whether you are able to create the sp_help_revlogin stored procedure.

Thanks in advance
Sreenath

[rmiao]

You can use dts transfer logins task, it copies sql logins with password.

[kpsreenath]

The next option was to create the transfer tasks, but the server is so very slow ..the cpu peggs at 100% and its hanging for ever...
rmiao, is this script running fine on your servers ?
I ran it on atleast 5-6servers and everwhere i am getting the same error.
Just wanted to understand, whether its a global problem because of any change in the script from the microsoft end.

[rmiao]

I never tried that script.