Click here to Skip to main content
15,561,246 members
Please Sign up or sign in to vote.
4.00/5 (4 votes)
See more:
Dear Friends,

Is it possible to use more than one sqldependency on the same form simultaneously? I want to monitor multiple sql server tables.

Thanking you in anticipation.

SKPaul
Posted
Updated 25-May-11 10:27am
v2

1 solution

Need to add more words because this won't except a simple, yes
 
Share this answer
 
Comments
Sergey Alexandrovich Kryukov 25-May-11 15:26pm    
Something told me it would be simple "yes" but I would be afraid to ask :-)
He he. My 5.
--SA
jeremycafe1111 15-Dec-11 9:22am    
Is this true? I have multiple SqlDependency objects and while it works, I end up maxing the server's memory out by the days end. When creating multiple depedencies, the previous ones never get cleaned up. I cant even figure out where to manually clean them out of the server.
[no name] 15-Dec-11 12:25pm    
Maybe this will help. http://www.codeproject.com/KB/database/chatter.aspx
You can see here where the Queues and Services are located so they can be manually removed.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900