I was curious about the feature that you're trying to implement.

-Mike

>I mean something like this:
>
>CREATE PROCEDURE Check AS
>
>declare @RetCode int
>select @RetCode=1
>
>While @RetCode=1
>Exec @RetCode = ExistFile 'NomeFile'
>
>-Michele
>
>>I'm curious. Would you mind providing more information about what you're doing? Specifically, when the stored procedure "loops."
>>
>>-Mike
>>
>>>I need to test if a particular file exist on my disk in a stored procedure.
>>>This S.P. must loop when the file exists and continue when this file is missing.
>>>
>>>Can anyone help me ?
>>>
>>>Thanks