ALTER PROCEDURE ISADMINUSER ( @UserName VARCHAR(100), @IsAdmin BIT OUTPUT )
AS
BEGIN
	DECLARE  @dbaccess 	BIT
		,@islogin  	BIT
		,@issysadmin	BIT

	SELECT 	@dbaccess = hasdbaccess
	       ,@islogin  = islogin 
	FROM 	master.dbo.sysusers
	WHERE	name = LTRIM(RTRIM(@UserName))

	IF (@dbaccess = 1) AND (@islogin = 1)
		BEGIN
			SELECT @issysadmin = sysadmin
			FROM  master.dbo.syslogins
			WHERE name = LTRIM(RTRIM(@UserName))
			IF @issysadmin = 1
				BEGIN
					SET @IsAdmin = 1
					RETURN 
				END
			ELSE
				BEGIN
					SET @IsAdmin = 0
					RETURN 
				END
						
		END
	ELSE
		BEGIN
			SET @IsAdmin = 0
			RETURN 
		END
END