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 |
|
michael_aussie
Starting Member
15 Posts |
 Posted - 2010-05-12 : 23:21:54
|
| I am looking for some sort of log table that tells me where my data has "gone" in SQL Server2005.In the application that runs on top of the SQL DB we enter information, but I can't find there it is going?I assume there must be a logging file that lists at the least the table that has been modifed.regards,Michael. |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2010-05-13 : 00:07:38
|
| Use Profiler to trace the statements being executed by the app. This would expose to you stored procedure calls or ad hoc sql statements. This will lead you to which tables are being modified. |
 |
|
|
michael_aussie
Starting Member
15 Posts |
Posted - 2010-05-13 : 00:10:19
|
quote:
Originally posted by nathans
Use Profiler to trace the statements being executed by the app. This would expose to you stored procedure calls or ad hoc sql statements. This will lead you to which tables are being modified.
Hi Nathan - you're going to have to hold my hand... where is Profiler? |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
|
|
michael_aussie
Starting Member
15 Posts |
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2010-05-13 : 00:25:05
|
| Please post back if you run into problems.- Nathan |
|
|
|
|
|
|
identifying tables that data has been written to