| Author |
Tables Last Accessed
|
|
| Danielle Roach 2006-04-03, 9:23 am |
| Hi,
Can anyone tell me if it is possible to see when a table was last accessed
in SQL 2000 Standard edition?
Many thanks
Danielle
| |
| Uri Dimant 2006-04-03, 9:23 am |
| Hi
Create a column as datetime datatype as default with GETDATE()
Create a trigger for update to handle this column for updating as well
"Danielle Roach" <Danielle Roach@discussions.microsoft.com> wrote in message
news:BBE8C24C-3728-491A-8778- DDA7BC9B5015@microso
ft.com...
> Hi,
>
> Can anyone tell me if it is possible to see when a table was last accessed
> in SQL 2000 Standard edition?
>
> Many thanks
>
> Danielle
| |
| Tom Williams 2006-04-03, 11:23 am |
| By 'accessed' do you also mean selected?
Danielle Roach wrote:
>Hi,
>
>Can anyone tell me if it is possible to see when a table was last accessed
>in SQL 2000 Standard edition?
>
>Many thanks
>
>Danielle
>
>
--
E-mail correspondence to and from this address may be subject to the
North Carolina Public Records Law and may be disclosed to third parties.
|
|
|
|