Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

are my print messages being sent to webserver? Expand / Collapse
Author
Message
Posted Thursday, March 07, 2013 4:40 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:44 PM
Points: 1,266, Visits: 2,912

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
Posted Thursday, March 07, 2013 7:36 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 7:27 PM
Points: 12,744, Visits: 31,080
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 »

Add to briefcase

Permissions Expand / Collapse