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