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).

"Manuel" <No****@NoMailLand.com> wrote in message
news:wt********************@giganews.com...

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

[Herfried K. Wagner [MVP]]

"Manuel" <No****@NoMailLand.com> schrieb:

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:news://news.microsoft.com/microsoft.public.dotnet.framework.adonet>

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

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[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]
"Robin Tucker" <id*************************@reallyidont.com> wrote in
message news:db*******************@news.demon.co.uk...

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

"Manuel" <No****@NoMailLand.com> wrote in message
news:wt********************@giganews.com...

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