Save and menage SSMS client messages

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Save and menage SSMS client messages

Save and menage SSMS client messages

Rate Topic

Display Mode

Topic Options

Author

Message

zambig

Posted Wednesday, February 06, 2013 6:29 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 07, 2013 6:06 AM
Points: 11, Visits: 24

Hi guys,
you know, there are some commands that generate client messages (those messages that are generated and shown inside the "result pane" along with errors).
For example when you run a DB check you get a message that tells the number of allocation errors, consistency errors and so on..
I know how to manage error warnings but I'd like also to intercept these messages and save them into a variable (or something else if needed) in order to enclose them to the mail body that my script sends at the end of the execution.

I've searched a lot on the web but I could not find any topic about my problem.
Has any of you ever had my same need and found a solution?

Thanks,
G.

Post #1416468

zambig

Posted Thursday, February 07, 2013 1:30 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 07, 2013 6:06 AM
Points: 11, Visits: 24

I think this is a good solution.

http://www.mssqltips.com/sqlservertip/1394/how-to-store-longer-sql-agent-job-step-output-messages/

Post #1416863

zambig

Posted Thursday, February 07, 2013 1:47 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 07, 2013 6:06 AM
Points: 11, Visits: 24

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).

Post #1416878

« Prev Topic | Next Topic »

Permissions