Using Return Value From A Store Procedure ?

Dear all,

I have a store procedure called ValidateUser which retrtive an authneticated ID from a database.
This procedure is defined as follow :




Code Snippet
ALTER PROCEDURE [dbo].[ValidateUser]
-- Add the parameters for the stored procedure here
@LoginId int = 0 OUTPUT,
@UserName varchar(50),
@pw varchar(60),
@LineId varchar(16)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- return the User id as validted
SELECT @loginID = Id
FROM [NomosConfig].[dbo].Users
WHERE [UserName] = @UserName
AND [PassWord] = @pw
AND [LineId] = @LineId
-- if no record returns, the request user is not allowed
if @@ROWCOUNT < 1
SELECT @loginID = 0

END




Runing this procesdure alone work well and return correct LoginId


What I would like to do is retrieve that return LoginID inside an other procedure. For that I am doinmg as follow :




Code Snippet
DECLARE @AuthenticatedUserId int;



-- verify that user is authorized to access to PSU login
EXECUTE @AuthenticatedUserId= [ValidateUser]
@UserName ='cal'
,@pw ='cal'
,@LineId='PR495250'
SELECT @AuthenticatedUserId




What is strange is that the @AuthenticatedUserId is always retunring 0 ..
Did I write something wrong ?

thnaks fro help
serge