I have many operations in the database that need to trigger application code. Currently I am using database polling, but I hear that SQL Server Service Broker can give me MSMQ-like functionality.
- Can I listen to SQL Server Service Broker queues from .NET applications running on a different machine?
- If so, should I do it?
- If not, what would you recommend?