Watching a SQL field for activity

  • Thread starter Thread starter shawncraig
  • Start date Start date
S

shawncraig

I was wondering if in VS2005 vb.net / SQL 2005 there was a better way
than having my program (service) firing off a SQL query every 1 second
to find out if a field had changed or been added. Yes I need to know
almost instantly if a change is made.

I know SQL has internal triggers but can they raise an event inside
another service?
 
I was wondering if in VS2005 vb.net / SQL 2005 there was a better way
than having my program (service) firing off a SQL query every 1 second
to find out if a field had changed or been added. Yes I need to know
almost instantly if a change is made.
Click to expand...

SQL Server Notification Services
 
Back
Top