April 26, 2002 at 12:36 pm
i would like be able to trap the output from nocount off to a log file. we have a number of stored procedures that run as nightly jobs, and i would like to be able to see what happened, step by step, the next morning. is this possible? thanks in advance.
April 26, 2002 at 2:03 pm
Easiest way is to set up a generic log table, insert the proc name, a comment, etc, then have a job to email it or dump to text file or whatever. If you build the code to do the logging into a proc of its own its pretty easy to add in whereever you need it. I often log stuff from applications much the same way, just pass a string with a bunch of info to a proc that logs it, helps in debugging.
Andy
April 26, 2002 at 2:11 pm
rather than pick entry points throughout the main proc to monitor each of the pertinent steps, i was hoping to simply tap into the done_in_proc output stream and use it as my monitor. can this be done?
April 26, 2002 at 2:20 pm
Not that I know how to do. Possibly at a very low level, either in SQL or part of the ODBC/OLEDB layer. Only other suggestion I have is to profile.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply