Post reply

Stored Procedure - output logging

  • January 5, 2004 at 5:04 pm

    #160585

    Hello,

    Does anyone have another way of storing the error msgs, and general output from a stored procedure without using xp_cmdshell.

    I have many SP's that run and produce a lot of output, and using xp_cmdshell was slowing the whole process down dramatically. I changed to logging this output to tables, but I'm looking for another way to create a text file log - without using xp_cmdshell.

    thanks

    Hitesh

  • January 5, 2004 at 5:28 pm

    #488741

    Since you are already logging to a table simply create a job that periodically BCP's the log table to your text file.




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply