Monitor changes to SQL Server Database?

[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

 

[r937]

i think you'll have a much better chance of getting that question answered in the Microsoft SQL Server forum, this forum is for ANSI SQL

r937.com | rudy.ca