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

when a new record is inserted into one of the table?
Or, we should maintain the messaging by ourselves?
Thanks.
hi,
zhaounknown wrote:
> when a new record is inserted into one of the table?
> Or, we should maintain the messaging by ourselves?
> Thanks.
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.shtmhttp://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
|||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
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3b036cF6fh560U1@.individual.net...
> hi,
> zhaounknown wrote:
> 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.shtmhttp://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
>