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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy