Viewing 2 posts - 1 through 2 (of 2 total)
The only problem is that it explains how to do this within a Job.
I don't think it is possible to adapt this for SPs (or scripts outside Jobs).
February 7, 2013 at 1:47 am
#1585258
I think this is a good solution.
http://www.mssqltips.com/sqlservertip/1394/how-to-store-longer-sql-agent-job-step-output-messages/[/url]
February 7, 2013 at 1:30 am
#1585243