CREATE PROCEDURE ProcValidateUser 
	@PUser AS NVARCHAR(30), 
	@PPassword AS NVARCHAR(30), 
	@PFirstName AS NVARCHAR(50) OUTPUT, 
	@PLastName AS NVARCHAR(50) OUTPUT, 
	@PRowsAffected AS INT OUTPUT	
AS
BEGIN	
	SELECT 
	COUNT(*) AS PRowsAffected
	FROM tblUsers 
	where UserName = @PUser 
	AND 
	Password = @PPassword

	IF PRowsAffected > 0 
		SELECT 
		FirstName AS PFirstName, 
		LastName AS PLastName, 
		PRowsAffected 
		FROM 
		tblUsers 
		WHERE UserName = @PUser AND Password = @PPassword;
	ELSE		
		return PRowsAffected;
	END IF
END
GO

This is to validate  a user login from a ASP .NET page!
TY

quote:

---

This is to validate a user login from a ASP .NET page!

---

Membership.ValidateUser(Login1.UserName, Login1.Password);