Database clean Up

#1

Hi,

We are in a process of cleaning all our databases. We want to delete all the
objects( Basically tables, Views, stored Procedures) which have not been used
since 2003.
My question is how to figure out that when was the last time the object was
accessed and who was the user who accessed this object and when was the
lastime it was accessed.

Is anybody having any script written already or if you can reflect which
systables i can use to find this info will be helpful
Thank You much in advance.

SP

#2

You cannot get this information from any tables. SQL Server has no record
of who accessed what tables in the way you want.

--

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

"SP" <SP (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

We are in a process of cleaning all our databases. We want to delete all
the
objects( Basically tables, Views, stored Procedures) which have not been
used
since 2003.
My question is how to figure out that when was the last time the object
was
accessed and who was the user who accessed this object and when was the
lastime it was accessed.

Is anybody having any script written already or if you can reflect which
systables i can use to find this info will be helpful
Thank You much in advance.

SP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Database clean Up

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Database clean Up - 08-15-2006 , 04:42 PM

Re: Database clean Up - 08-16-2006 , 12:55 AM