| Author |
notify a client application when a database change occurs
|
|
|
| Hi
I'm looking for solutions to notify a client application when a database
change occurs.
I have a Windows application written in VB.NET
Thanks
| |
|
| Unless you don=B4t use SQLServer 2005, there is no way to do this
automatically. IN SQL Server 2005 you have query notifications
whichwill keep you informed of database changes as well as schema
changes. Prior to SQL Server 2005 there has been only the option to use
Notification services. As you didn=B4t stated which version you are
using, try to look in a little deeper in on of these options.
HTH, jens Suessmeyer.
| |
|
| Hi
I'm using MSDE 2000.
What about trigger that will send a message by MSMQ or raise an event?
"Jens" wrote:
> Unless you don´t use SQLServer 2005, there is no way to do this
> automatically. IN SQL Server 2005 you have query notifications
> whichwill keep you informed of database changes as well as schema
> changes. Prior to SQL Server 2005 there has been only the option to use
> Notification services. As you didn´t stated which version you are
> using, try to look in a little deeper in on of these options.
>
>
> HTH, jens Suessmeyer.
>
>
| |
| Norman Yuan 2006-02-01, 9:24 am |
| You are out of luck. MSDE2000 does not support SQL Server Notification
Services.
A "bad" idea:
"Rami" <Rami@discussions.microsoft.com> wrote in message
news:216F7E90-5F7C-40EA-90A3- FA5C9F300694@microso
ft.com...[color=darkred]
> Hi
>
> I'm using MSDE 2000.
>
> What about trigger that will send a message by MSMQ or raise an event?
>
>
>
> "Jens" wrote:
>
|
|
|
|