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