question

srivivek avatar image
srivivek asked

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
sql-server-2000tableinformation_schemamodified_date
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
In SQL Server 2000, you don't have modified date on objects.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mark avatar image Mark commented ·
That's what I thought, but wasn't too sure about it.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.