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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-11 : 08:51:35
|
| Rajesh writes "I have a query. I need to delete the tables which have not been accessed (no select,insert,update,delete query executed on the table & of course it is not referenced by any other table) forsome period say past 3 months. Now i can create a trigger to keep track of timestamp of the last operation. But the problem is no trigger is fired on the select statement. Does sql server internally store timestamp of the last operation just as we have it in FAT in case of files. Please advice me on this.Thanks for replying to my previous queries & for this one too in advance." |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-02-11 : 10:08:40
|
| You might find what you're looking for in sysobjects or one of the other system tables in the "master" database. Check the Books Online.Edited by - andre on 02/11/2002 10:16:17 |
 |
|
|
|
|
|
Deleting unaccesed table