Well u dont have to be so harsh..........Well its SQL 2000 & 2005 ,
moreinterested in SQL 2000 what column to add and how to find out


Thanks Aishu


"Aaron Bertrand [SQL Server MVP]" wrote:

> Do you have any idea which version of SQL Server you are using? If so, why
> not mention that?
>
> If you are using SQL Server 2000, you will need to have a column that
> captures that information and update it yourself, since this information is
> not tracked.
>
> In SQL Server 2005, certain DMVs will give you information about when
> indexes are updated, which may be enough information for this purpose.
>
>
>
> "Aishu" <Aishu@discussions.microsoft.com> wrote in message
> news:BDD339D4-95D0-4589-BD7C-840B565A6934@microsoft.com...
> > HI there,
> > I want to find out on when the database and the objects were last used so
> > that we can do some cleaning up and sent it for archiving...
> > Thank You
> >
> > Rgds,
> > Aishu
> > MCSE,MCDBA,MCSA
>