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 |
|
Mits
Starting Member
48 Posts |
 Posted - 2003-12-04 : 10:29:17
|
| Hi all,I have more then 100 tables in my database. This tables has been created by someone who has left the company and many of them are not used at all. Is there any way by which i can find out when was any table last updated or modified, so based on that i can remove tables.thanks and byeMits |
|
|
Amethystium
Aged Yak Warrior
701 Posts |
Posted - 2003-12-04 : 11:00:30
|
| Good question, I think the refdate is updated if the a table is modified through EM but doesn't seem to change if the structure of the table is modified using T-SQL in QA.Come to think about it, how about you get in touch with your DBAs who can refer to the transaction logs. That way they will be able to tell you who and when had access to which table.________________Make love not war! |
 |
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2003-12-04 : 11:08:58
|
| You can always run SQL profiler to see which tables are active. |
|
|
|
Mits
Starting Member
48 Posts |
Posted - 2003-12-04 : 11:43:48
|
| thanks 1fred,i dont quiet understand. i mean i dont know how to use SQL profiler? it would be really helpful if you could explain in detail.thanksMits |
|
|
|
Mits
Starting Member
48 Posts |
Posted - 2003-12-04 : 12:18:02
|
| thanks 1fred,i dont quiet understand. i mean i dont know how to use SQL profiler? it would be really helpful if you could explain in detail.thanksMits |
|
|
|
|
|
|
Table Properties