is there a way to capture database messages that a script generates while using SqlCommand?

Question

I'm running some scripts on a database programmatically. The script produces 'light' errors like so:

RAISERROR (N'[dbo].[TheTableName]: Inserted ACME information: 1.....Done!'
   , 10, 1) WITH NOWAIT;

Redgate-generated scripts seem to generate a lot of these. They're actually helpful with what I'm doing, so I'd like to capture them and show them to the user. But I'm pretty sure they get swallowed up when you run the script via .NET. Is that correct?

Marc Gravell · Accepted Answer · 2010-03-11 16:35:52Z

2

The messages are events on the connection; look at SqlConnection.InfoMessage, or the example here.

answered Mar 11, 2010 at 16:35

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

is there a way to capture database messages that a script generates while using SqlCommand?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related