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 |
|
vicki
Posting Yak Master
117 Posts |
 Posted - 2002-04-12 : 09:41:17
|
| Hi,Is there any why to find out what was the las update/used for the database?, How?Thanks a lot |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-12 : 09:53:14
|
| Not unless you create a specific audit tracking feature, and write triggers to log this information. You'd have to apply these triggers to every table you want to track.You could also do this using SQL Profiler, but it will capture pretty much everything, not just updates. Books Online will have more detail on what you can do with Profiler. Be warned that tracing a lot of activity will lower the performance of your SQL Server. |
 |
|
|
|
|
|
date