Previous Thread:   Index on UDT

2/14/2006 9:13:08 AM    Re: SqlDependency
Are you planning to scale this application? How broad is your SELECT? How  
  
often is this table changed by other users?  
  
--  
  
____________________________________  
  
William (Bill) Vaughn  
  
Author, Mentor, Consultant  
  
Microsoft MVP  
  
INETA Speaker  
  
www.betav.com/blog/billva  
  
www.betav.com  
  
Please reply only to the newsgroup so that others can benefit.  
  
This posting is provided "AS IS" with no warranties, and confers no rights.  
  
__________________________________  
  
"Gouri" <gourisohoni@hotmail.com> wrote in message  
  
news:OQc5hMWMGHA.1132@TK2MSFTNGP10.phx.gbl...



2/14/2006 6:00:04 PM    Re: SqlDependency
You should re-register your app in order to receive query notifications  
  
after you've received one...  
  
--  
  
WBR, Evergray  
  
--  
  
Words mean nothing...  
  
"Gouri" <gourisohoni@hotmail.com> wrote in message  
  
news:OQc5hMWMGHA.1132@TK2MSFTNGP10.phx.gbl...

2/14/2006 6:05:23 PM    SqlDependency
Hi,  
  
I am trying to use SqlDependency to keep track of any changes on the data.  
  
The program works fine when change in the data occurs for the first time,  
  
but the event is not captured if more changes are made.  
  
Thanks  
  
Gouri