declare @clearpwd varchar(255)
declare @encryptedpwd varbinary(255)
select @clearpwd = 'test'
select @encryptedpwd = convert(varbinary(255), pwdencrypt(@clearpwd))
select @encryptedpwd

pwdcompare(@old, password, (case when xstatus&2048 = 2048 then 1 else 0 end))

declare @clearpwd varchar(255)
declare @encryptedpwd varbinary(255)
select @clearpwd = 'test'
select @encryptedpwd = convert(varbinary(255), pwdencrypt(@clearpwd))
select pwdcompare(@clearpwd, @encryptedpwd, 0)
select pwdcompare('errorpassword', @encryptedpwd, 0)