Using the code provided from MS in note How to transfer logins and
passwords between instances of SQL Server http://support.microsoft.com/kb/246133

I am getting the following error from the generated code for some (but
not all) of the create user statements.


Msg 15021, Level 16, State 2, Line 1
Invalid value given for parameter PASSWORD. Specify a valid parameter
value.

CREATE LOGIN [A70_109] WITH
PASSWORD=0x0100CD64B478FDAB3292582542D63B1D727875B B6A28484A19C5FDAB3292
HASHED, CHECK_POLICY=OFF, SID=0x0A7DD299FDB0744CACB50FF391FC0036

The source db is MS SQL Server 2000 and the target is MS SQL Server
2008 R2.

Any ideas?