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.
Answer by michael_aussie ·
nathans answered this from me. I needed to use Profiler, a seperate program to Server Management Studio. ty nathans
Originally posted by nathans You can find under Tools menu in Mgmt Studio. This has some great screenshots to guide you: