I am using using a table as a message queue and "signing up" for up for updates by using a SqlDependency. Everywhere I read people are saying look out for the limitations of it but not specifically saying what they are. From what I've gathered you will have problems when the table has very high update frequency, fortunately I'm only looking at 10 - 20 values per minute maximum.
What are the other limitations/impact on the SqlServer?
The most complete list I can find (from here) is as follows:
There are also a couple additional pieces of information: