Table Last Updated? 2

[Skittle]

Is there a way to determine when an SQL Server 2000 table was last updated?

Can't see it in the system stored procedures.

Dazed and confused

 

[mutley1]

Hi Skittle,

Not as far as I'm aware, unless one of your fields is a date / time stamp, or you have a trigger auditing transactions on the table.

Unless any of the experts here can think of anything.....

HTH,

M.

 

[ptheriault]

There is not any way to tell without the use of your own audit triggers. If it's 2005 you can create DDL triggers checking for DDL events.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mutley1]

The only other thing I forgot to mention is you could use a 3rd party tool like Lumigent Log Explorer, but that depend on ow often you want to know when items changed (e.g. if you do a Tran Log backup hourly but want to know at the end of the day who did what - that might be difficult!).

 

[Skittle]

OK thanks dudes

Dazed and confused

 

[mutley1]

Good Luck,

Instead of the HTH, i should have put SIBN (Sorry it's bad news).

M.