auto-dectect changes in SQL Server 7.0 ?

[ndtai]

I want to write a programme who will auto-detect the changes in my database in SQL Server 7.0. Normally, it is in systray. When sommeone changes my database, it will show an alert. How can I dectect changes in database in SQL Server 7.0 ?

[MAK]

Define "changes in database"

data changes: insert, delete, update
structure changes: create, drop, alter
Security changes: logins, users, roles

In other words: DDL,DML,DCL

You could run SQL Profiler and captures the result in a table (create trigger in the table for alerting )all the changes.

[ndtai]

How can I catch events DELETE, INSERT and UPDATE from my application, not in SQL Server ?
Thanks

[MAK]

If you are looking for changes (insert delete and update) on a table or list of tables from the App then....

all your tables should have a insert, update and delete trigger which will writes the log (with time stamp) on a table.

your app' should check that table every min comparing the current system time and the timestamp on the log table.

[MAK]

you could run profiler which captures the insert, update and delete on a table.

your app can look up on that log table every 1 min for changes.