Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arundkulk
Starting Member
4 Posts |
 Posted - 2004-08-18 : 15:40:35
|
| I include PRINT statements in the stored procedures. These help to debug them. Executing stored procedures in the Query Analyzer enable to view the output of these PRINT statements in the results pane. Is there any way to get this output back in an application using ADO.Net? |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-18 : 18:12:50
|
| uhhhh, have you thought about using the debugger in VisualStudio.NET?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2004-08-18 : 18:21:19
|
| You will need to hook up the information event. Works like a treat but performance suffers..DavidM"Always pre-heat the oven" |
|
|
|
arundkulk
Starting Member
4 Posts |
Posted - 2004-08-19 : 09:57:34
|
Can yo be little more specific. I did not understand. quote:
Originally posted by byrmol
You will need to hook up the information event. Works like a treat but performance suffers..DavidM"Always pre-heat the oven"
|
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
|
|
arundkulk
Starting Member
4 Posts |
|
|
arundkulk
Starting Member
4 Posts |
Posted - 2004-08-20 : 14:51:06
|
Thanks, It worked out great!quote:
Originally posted by byrmol
You will need to hook up the information event. Works like a treat but performance suffers..DavidM"Always pre-heat the oven"
|
|
|
|
|
|
|
Getting back SQL output in .Net application