are my print messages being sent to webserver?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » are my print messages being sent to...

are my print messages being sent to webserver?

Rate Topic

Display Mode

Topic Options

Author

Message

curious_sqldba

Posted Thursday, March 07, 2013 4:40 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 4:13 PM
Points: 1,172, Visits: 2,687

We have bunch of sprocs which print out actual sql statement in message tab( was enabled for debugging but never disabled !!!). Would these print messages also been sent to webserver? Is there anyway i can find this out? Web application is in .net.

Post #1428325

Lowell

Posted Thursday, March 07, 2013 7:36 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 11,648, Visits: 27,768

Yes print messages are available as part of the. Net connection object but you have to add a event to it i believe in order to extract them. I have an enhanced Sqlhelper class on my other puter with the example but this is the basics

They are ignored unless you add something to display them

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.infomessage.aspx

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1428346

« Prev Topic | Next Topic »

Permissions