EDN Admin
Well-known member
SqlDependency event OnChange doesnt work when i use stored procedures to get my data, or by other words, doing the selects of what i want. I know for a fact if i write the query in the CommandText (without using stored procedures) of the SqlCommand object,
the event works like a charm.
So i dont understand why is that... Does the Service Broker or the SqlDependency doesnt work too well if you use stored procedures to retrieve the data?
Thanks in advance!
View the full article
the event works like a charm.
So i dont understand why is that... Does the Service Broker or the SqlDependency doesnt work too well if you use stored procedures to retrieve the data?
Thanks in advance!
View the full article