CREATE PROCEDURE Validar_Pass_Prueba
(
@login varchar(255), --login
@password varchar(255), --contraseña
@error int = 0 output --me tira error si existe
)
AS
if exists
(select * from sys.syslogins where loginname=@login and 1 = pwdcompare(@password,password,0))
select @error = 1
else
select @error = 0
print @error