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 |
HadasW
Starting Member
2 Posts |
Posted - 2007-11-07 : 04:45:14
|
we want to delete un-used tables from a db.but we want to be sure that no one uses those tables (select\update\insert\delete). is there a way to create a monitor or something to know when the table was last touched?we dont want to create a trigger on each table, caue there are too many tables.pls help.... |
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-07 : 04:51:45
|
have you used sql profiler before? that will show you activity on the server / db / table etc..Em |
|
|
HadasW
Starting Member
2 Posts |
Posted - 2007-11-07 : 07:56:39
|
in that case - the profiler needs to run in the backend for the duration of time (let's say a week) that we want to check the tables activity.Does it consumes performance from the server while it runs?Does it save its results to some file or something we can later inquire? |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-07 : 08:04:44
|
i would normally try and run it from a remote server where possible and you can have the results save to a file or to even to a table for you to query later. look at the different filters available to narrow down what you're looking for tooEm |
|
|
|
|
|