No, not natively. You can add a trigger that will update a datetime column
but it has to be done manually.
Andrew J. Kelly
SQL Server MVP
"Jesse Fitterer" <anonymousdevdex.com> wrote in message
news:%23D$%234v2PDHA.2676TK2MSFTNGP10.phx.gbl...> Without going to the table itself, can we determine if and when a table
> has been changed after its creation date? I know the sysobjects will
> list the creation date (crdate) but is there a way to see when the table
> has been last updated. (Update,insert, delete)
> *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!