Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1sqlover
Yak Posting Veteran
56 Posts |
 Posted - 2006-05-23 : 14:28:13
|
| 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.Thanksepoh |
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2006-05-23 : 14:38:09
|
| You could use Profiler and choose the standard(default) template. Let this run for a while and then you could search the TextData column for your "one" change. |
 |
|
|
|
|
|
Monitor changes to SQL Server Database?