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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-17 : 08:14:47
|
| Igor writes "My Question:I would like to turn the tables I guess. Normaly the client sends a message to the server and then the server returns data and or error to the clientWhat I would like to know is how do I with a RaiseError send a message to a client with a open connection? My client software is waiting for error messages but is not getting them.I am developing in VB.NET and C#Igor" |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-09-17 : 10:20:44
|
well you could use SqlCommand.ExecuteNonQuery() in C#from client...but how would you know when to send the message from server??Go with the flow & have fun! Else fight the flow  |
 |
|
|
DustinMichaels
Constraint Violating Yak Guru
464 Posts |
Posted - 2004-09-17 : 10:25:37
|
| If the error level is at least 16 it will throw an Exception in your .NET program. So if your using Sql ADO objects try catching an SqlException object.Dustin Micahels |
|
|
|
|
|
|
RaiseError EVENTS