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 |
|
access4forums
Starting Member
3 Posts |
 Posted - 2010-01-05 : 14:05:48
|
| Is there a table in SQL SERVER 2005 that maintains the drop index history?Thanks,isa |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2010-01-05 : 20:18:53
|
| Not that I am aware of. You could create a DDL trigger that looked for this type of activity and log the history to a table for later review.=======================================Few things are harder to put up with than the annoyance of a good example. (Mark Twain) |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-01-06 : 04:44:13
|
| If you're trying to find out when an index was dropped, you could look in the default trace, providing the drop didn't happen too long ago. The default trace is a light-weight server-side trace that keeps only 4 files of 20MB of trace data.If you want this for future, then consider a DDL trigger and a table to store history.--Gail ShawSQL Server MVP |
|
|
|
access4forums
Starting Member
3 Posts |
Posted - 2010-01-06 : 16:32:09
|
| I am hoping its onetime only thing...i am trying to debug a issue...where are the default trace located?~isa |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-01-07 : 03:36:22
|
| In the SQL error log directory.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Drop Index history