Is this a syntax error ?
===

if( @ActiveStatus = 1 ) 
begin 
@PasswordStatus = 3 
END
else 
Set @PasswordStatus = (select password_status from tbl_user	where  login_name=@LoginName_fromApp and password=@Pass)


I am using Microsoft SQL Server Management Studio.. 
