0 down vote favorite
I have an application which uses sql service broker and sql
dependency in c# application. Its working fine when my database is at
the local machine but it does nothing when the database is at remote
system. I checked the service broker is enabled but nothing happens when
i change the tables data where i have implemented sql dependency to get
notifications when the table data changes.
Any help how to figure it out. I have very less knowledge about sql service broker.
I am using sql 2012 but the database is working on 2005 instance