title: SQLDependency in ASP.NET with Stored Procedure
body: <p>I have used <code>SqlDependency</code> in <code>asp.net</code> to get notifications in application.  I want to use <code>SqlDependency</code> with sql stored procedure.  My stored procedure fetches records from more than 1 one table using join operation. </p>
  
  <p>But, <code>SqlDependency</code>is not working here.</p>
  
  <p>Can <code>SqlDependency</code> work with stored procedure or not?</p>
  
  <p>If yes how I can use it..</p>