sql server msde: Can MSDE or SQL Server send an active message to the client? -- sql server msde

You're in the

sql server msde

group:

Can MSDE or SQL Server send an active message to the client?

zhaounknown
3/30/2005 8:25:09 AM

sql server msde:

when a new record is inserted into one of the table?
Or, we should maintain the messaging by ourselves?

Re: Can MSDE or SQL Server send an active message to the client?

Andrea Montanari
3/30/2005 6:41:44 PM

hi,
[quoted text, click to view]

actually this is a very bad practice as you'd overhelm the server
activities..
what kind of message would you like to send? over the whole network?
you can perhaps implement some NET SEND in insert/update/delete trigger, but
again, this is very poor..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Re: Can MSDE or SQL Server send an active message to the client?

Greg Low [MVP]
3/31/2005 9:17:19 AM

In addition to what Andrea mentioned, take a look at the SqlDependency class
in VS.NET2005/SQL Server 2005. You can use that with SQL Express (the MSDE
replacement). I suspect it's just what you're looking for.

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server msde group.

home · blog · groups

Questions? Comments? Contact the dn