Where to check for modified date of a table in sql 2000

Hi, Where to check for modified date of a table in sql 2000,as if we can check in sql 2008 using select name,create_date,modify_date from sys.tables

asked Sep 06 '11 at 02:17 PM in Default

srivivek
519 ● 30 ● 39 ● 42

(comments are locked)

1 answer:

In SQL Server 2000, you don't have modified date on objects.

answered Sep 06 '11 at 03:02 PM

Magnus Ahlkvist
13.7k ● 13 ● 17 ● 30

That's what I thought, but wasn't too sure about it.

Sep 06 '11 at 03:06 PM Mark

(comments are locked)

Your answer

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Topics:

asked: Sep 06 '11 at 02:17 PM

Seen: 648 times

Last Updated: Sep 06 '11 at 02:55 PM