Monitor changes to SQL Server Database tables

[epoh]

Hi all:

Is there a way I can monitor changes to a SQL Server Database?

I have an applications SQL DB that has over 600+ tables. I am just looking for one change, so I can create a backup. I want to monitor all tables at once, since I am not sure which one is the one I need.

Is this possible or does such a tool exist. I am thinking of a tool similar to regmon or filemon.

Thanks

 

[bikerboy718]

You should be able to use profiler.

With Great Power Comes Great Responsibility!!!

Michael

 

[timscronin]

If you are looking at full time changes, there are several products out there which do this rather nicely (Apex and Softreech)