I was doubtful of the solution posed in this artcle also, so I did my own tests. I got similar results as found by bobjbian.  The static cursor beat all...

Well, I thought I described what the script does... it "cracks" or "displays" the passwords for all of your linked server user ids.  We had some linked server ids (from...

The password is probably stored using Unicode (wide-char) not ASCII.  Try using:

select cast(user_password as nvarchar (256))from user

Example:

create table #user (username varchar(20), userpassword varbinary(256))

go

insert into #user (username,userpassword) values ('ascii',convert(varbinary(256),'123abc'))

insert into...

This might be a little late, but might prove helpful to future searchers looking for a solution.

You can't transfer the passwords for remote logins like you can with normal logins. ...