title: Alternative for sqldependency
body: <p>I have a mssql table that holds chat information. It has computed columns, has millions of rows and is being used/populated by an third party application. Now I want to use this table to show chat history on my website and possible in future have the ability to send messages using signalr. 
  I did a couple tests using sqldependency and it works but only for specific queries that will not help in my case(I have to exclude the computed columns, cannot order by last msg, cannot set top 100 messages etc)</p>
  
  <p>So my questions is what would be an alternative? using a webservice that polls the database every x seconds?</p>
  
  <p>Side note, i have no influence on the table at all.</p>