sql server programming: I want to check when and which time the tables are altered by users and
whether they are directly altered in the table or by using the query
analyser. tell option to audit the above information

There is a simple you could implement: 1)add a Trigger to your tables that
stores the "audit" info in anothe table. You would need to store the object
name,user logged on , date.
If you needed to store the changes they have made , thrn you would need to
look at things such as saving the record initially , and then doing the
update

--

Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/SQL




[quoted text, click to view]

If you are in SQL Server 2005
select name,modify_date from sys.tables

order by modify_date desc





[quoted text, click to view]

[quoted text, click to view]

If it is a one-time investigation and not a permanent need, use the
Profiler.