c# SqlDependency on a mirro db

[want 2 Learn]

Hi, I wanted to add SqlDependencyEx to my project.

when I tried

ALTER DATABASE MYDBSET ENABLE_BROKER WITH ROLLBACK IMMEDIATE



I got error

Cannot create a new Service Broker in a mirrored database "MYDB".

I checked and the only way is to remove the mirror and return it.

is there any other way i can do to check changes in a table?

Continue reading...