Post reply

Write to log SQL Log directory?

  • July 5, 2006 at 7:43 am

    #61443

    Is there an easy way to write to a file in the SQL log directory - much like a maitenance job can be setup to do?

    RH

  • July 5, 2006 at 9:31 am

    #647533

    i am not clear with the problem. you want to create a text file using SQL Server?

  • July 5, 2006 at 10:56 am

    #647560

    Yes.  The same way maintenance jobs are able to write history to files in the log directory.  I'm curious if someone knows how SQL Server is doing that and if it is easily duplicated for non system maintenance jobs.

  • July 5, 2006 at 1:25 pm

    #647608

    Sure. We do that sometimes. Add a job step or a DTS package task of ActiveX Script type and use FileSystemObject to get to the files.

    Regards,Yelena Varsha

Viewing 4 posts - 1 through 3 (of 3 total)

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