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 |
|
asafg
Starting Member
39 Posts |
 Posted - 2009-05-25 : 06:57:30
|
| I have a stored procedure with long executing time.when I run it from within the management studio I can use the raise event - to check the progress (e.g: I'm working on step 2/10)I need the sqlserver to return such string to C# or any other language.Is it possible howwhen I googled the subject I found someone that said that there is a error stream that should be a thread... Any ideas what he meant? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-25 : 07:01:04
|
| The error stream will probably only be available when the query completes.You could log the entries to a table then read them from the app?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
asafg
Starting Member
39 Posts |
Posted - 2009-05-26 : 09:17:35
|
| Peso ...from the sql side it works great...RAISERROR('HELLO WORLD.', 12, 1) with nowait the problem comes from the application sidethe sql connection returns all the errors I raise but only a f t e r the execution is complete...I need the application to read all the messages sent from the sqlserver - immediately when sent.I fount in c# the commandFireInfoMessageEventOnUserErrorsbut it doesnot seem to do any thingAny ideas?10x alot for the help |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-26 : 09:20:49
|
| lol - read my previous post.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
|
|
|
|
|
get SQLServer messages on C# vb or other language