I would like to know if there is a way to check if a SQL Server database changed based on some query.
I've already tried SqlDependency, but i think it's restricted on the inner join and simple selection queries, and I've read that it has memory leak problem.
Is there a better way to do this?