Is the SQLDependancy Class supported in SQL Server Express? I have code that is working that uses the SQLDependancy and SQL Server Express but I have seen many post around the internet saying that this feature is not supported. I do not want to use this feature to later find out that a service back breaks it or that Microsoft will not do support for it.
Thanks Jon
I've wrote a component that take advantage of the query notification macjanizm, i use this component in a web service , and its working great, with a little problem , i have imporsonation enabled in my web service and a user and password is set in the identity node in web.config , the impersonation is working great and the web service is running under the user name i've set in the web.config , but, when i change a table in the database and the change event is raised in my application the user name is no more the user in the web.config...The user is now ASPNET ....
How can i solve this problem of user name change?
Thanks in advance ,
Eden
I have an sql dependancy setup on a particular table that is not updated all that often. When I load my application that has the dependancy code in it, the onChange event of the SqlDependancy fires over and over again non stop. I am positive I am not updating the information in the table I am querying so I can not figure out why it would do that. But I bet one of you knows! If you need code I can supply it and if you need anything else let me know. Thanks in advance.
View 9 Replies View Related