Catch SQL Server events

[Manuel]

With the FileSystemWatcher I can catch the events of a directory. Is there a
way to do the same with a SQL Server table? (catch any modification to the
data)

I read all I could find about the SQL Server Notification Services but
couldn't find what I was looking for. If there is a way to do this, please
include a short example.

Thx

 

[Robin Tucker]

I think this is available with the next release of SQL Server (some
notification services). However, I would prefer polling for changes
(checking yourself).

 

[Herfried K. Wagner [MVP]]

With the FileSystemWatcher I can catch the events of a directory. Is there
a way to do the same with a SQL Server table? (catch any modification to
the data)

Notice that a separate group for .NET+database questions is available. You
will more likely get an answer there:

<URL:
The SQL Server groups can be found in the "microsoft.public.sqlserver.*"
groups hierarchy.

 

[m.posseth]

Robin ,,, it is also availlable in SQL 2000 however then you need to do a
extra install
see :
http://www.microsoft.com/sql/NS/default.asp

regards

Michel Posseth [MCP]