Hello

I´m using MS-SQL Server 2k with a custom application connecting to it.
I need a quick and simple way to detect any change (insert, update, delete)
to my database (not just to a single table). The purpose is to notify
somehow different instances of the application about the data changes,
since they should refresh their local query results.

Is there any function, stored procedure, system database entry, etc. I can
exploit to get the job done? Can you suggest me the most suitable mechanism
to implement this?

T.I.A.

AndreA

"AndreA" <andrea.galbusera@teamware.it> wrote in message
news:c4recb$89p$1@grillo.cs.interbusiness.it...
> Hello
>
> I´m using MS-SQL Server 2k with a custom application connecting to it.
> I need a quick and simple way to detect any change (insert, update,
delete)
> to my database (not just to a single table). The purpose is to notify
> somehow different instances of the application about the data changes,
> since they should refresh their local query results.
>
> Is there any function, stored procedure, system database entry, etc. I can
> exploit to get the job done? Can you suggest me the most suitable
mechanism
> to implement this?
>
> T.I.A.
>
> AndreA
>

You can use triggers on the tables you want to audit, or perhaps use a
product which can read the transaction log and generate an audit trail:

http://www.lumigent.com/products/entegra/entegra.htm

One other option is to create a server-side trace, although personally I
would use that only as a temporary solution or to find a specific problem.

Simon