Re: Notification to WinForm programs in a LAN. Is there a Delivery Proto
Sure, you can probably do that in SQL Server 2005. But, the risk there
is that you're putting code in a trigger that could take quite a bit of
time to execute. This will, of course, have adverse affects on performance.
Triggers should be used judiciously to rollback, ensure referential
integrity, etc. I'd shy away from making .net remoting calls in them.
SQL Server MVP
Get up to speed quickly with SQLNS
Torbjørn Sigurdsen via SQLMonster.com wrote:
I followed Y Zhang's case over several forumors, but I never found a
conclusion. Would it not be a solution to create triggers that execute
stored procedures - as sprocs can be created i nC# in SQL Server 2005 as of
- and use the .NET framework combined with remoting to notify the
Am I totally of the wrong field or would this give Y Zhang ...and myself...
the close to real-time updates on the clients?
If you did come to a more direct solution using MSMQ I would appreciate a
hint on that as well.