Microsoft SQL Server Desktop Engine - Can MSDE or SQL Server send an active message to the client?

Author

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

zhaounknown

2005-03-30, 7:04 pm

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

Thanks.

Andrea Montanari

2005-03-30, 7:04 pm

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.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

Greg Low [MVP]

2005-03-30, 7:04 pm

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.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
>
>

Sponsored Links