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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MSMQ, COM and 32/64 bit compatibility 1
Multiple worker threads/objects pulling from the same MSMQ queue 2
.NET requirement ( local in DC ) 0
Access-SQL Server object dependencies 3
System.Transaction and MSDTC 2
saving object properties in sqlserver 1
Session Times Out but still logged in with login control? 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top