• Hi Charles,

    Thanks for the reply. My Stored Procedure contains the cursor. The output of the stored procedure contains all the Logins and their passwords and default database assigned. This all information when i execute on Query Analyser it will display output on the screen.

    I need to execute this stored procedure from Job scheduler and store the output some where in text file.

    Can you suggest me How you mention path of the file during execution of stored procedure?

    Please help me.

    Thanks,

    Anil