How can I find out the date a MS SQL Server 2000 object was last modified?

Vote count: 0

I need to get a list of all the tables,views, stored procs, functions etc that were modified last year in sql 2000. In sysObjects I can see the date objects were created but I need to know when they were last madified.

Note: this is a SQL 2000 database.

asked 35 secs ago

vinisha9

Let's block ads! (Why?)

How can I find out the date a MS SQL Server 2000 object was last modified?