Implementing Sql Object Dependency?

  • Thread starter Thread starter deostroll
  • Start date Start date
D

deostroll

If there was no such technology like MSMQ how would you try to
implement an sql server object dependency in your windows forms
application? Say I just want to keep updated with the information in a
particular table.

--deostroll
 
deostroll said:
If there was no such technology like MSMQ how would you try to
implement an sql server object dependency in your windows forms
application? Say I just want to keep updated with the information in a
particular table.

--deostroll
Click to expand...

Maybe by periodically polling or via another eventing mechanism (Remoting,
COM, WMI).
 
Use the Service Broker in SQL Server. It is basically MSMQ in SQL Server.
Check it out, it is pretty cool and functional.
 
We use this to essentially do the same thing, except that we are ending
messages to keep a second database not an application in sync. This has been
in our prod environment for over a year now, I would recomend it.
 
Use the Service Broker in SQL Server.  It is basically MSMQ in SQL Server.
Check it out, it is pretty cool and functional.







- Show quoted text -
Click to expand...

Is this available for sql server 2000?
 
Back
Top