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
Sep 06 '11 at 02:17 PM
Sep 06 '11 at 02:55 PM
In SQL Server 2000, you don't have modified date on objects.
Sep 06 '11 at 03:02 PM
That's what I thought, but wasn't too sure about it.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Sep 06 '11 at 02:17 PM
Seen: 648 times
Last Updated: Sep 06 '11 at 02:55 PM
Partitioning Tables In Sql Server 2000
Creating an Extended Stored procedure in SQL Server 2000
What's the best way to backup replication in SQL Server 2000?
Maintenance Plan x Transaction Log
SQL Server 2008 Reporting Services and SQL Server 2000 Analysis Services Error
Need SQL script for determining difference in pricing for records in table with same key but different dates
Database Optimization Maintenance error
How Do I Append Zeros To A Query Result?
Transaction inside Instead Of Trigger.
Switching from Bulk-Logged to Simple Recovery Model on SQL Server 2000
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.