Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Table Updated Date

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-27 : 09:06:47
Irfan writes "How to find out Table Updated Date if we change a design
Reply soon
Thanks"

efelito
Constraint Violating Yak Guru

478 Posts

Posted - 2002-06-27 : 12:00:13
When you create a table there is a date stamp on it. If you use alter table to modify the structure of it, I don't think that SQL Server tracks that date. If you want to know the date changes were made on using system info, you would need to drop the old table and create a new one with the changed structure.

Jeff Banschbach
Consultant, MCDBA
Go to Top of Page
   

- Advertisement -