Hi, is there anyway to view a table's activities history
info like updates, deletes? Does it have to be in log
somewhere or I can retrieve it somewhere else? Thank you
in advance.

You may be able to do this king of tracking in Lumigent's Log Explorer. You
should also be able to do this using triggers and audit tables. You will
not be able to log SELECT statements. For this you could use a Profiler
trace. A profiler trace would also see all other tyoes of activity against
the tables etc.

We are currently implementing a solution whereby we look at trace tables for
a predefined trace and extract the information about Server/Database/Table
activity by whom, when,what, reads, writes, CPU and duration.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"baobei" <baobei1627 (AT) aol (DOT) com> wrote