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 |
|
vdavid70
Yak Posting Veteran
67 Posts |
 Posted - 2005-11-17 : 12:46:32
|
| How do i find out within a sql 2000 database who has deleted a column or table belonging to a view as well as the table that was dropped in that view.Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-17 : 13:22:30
|
| Sniff the logs with Lumisent(SP?) tools; run Profiler at the time they do it to log their activity;use SQL2005 which allows capturing such infoRestore the TLog backups bit-by-bit to work out when the change happened, and maybe attribute it based on time to a particular individualNot altogether straightforwards!Kristen |
 |
|
|
|
|
|
delete Culprit