Please rate this item: 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

SQL: Return the MAX of all dates within all tables within all databases

I wanted to produce a list of the MAX of date fields (DateTime, SmallDateTime, TimeStamp) for all tables within all databases held in an instance of SQL Server.

The script below was written for SQL Server 2000, but should be easily customisable for SQL Server 2005

As always 1, please ensure you test any script taken from my website on a test/development machine, before running on a production server.

  1. Please ensure you test any script taken from my website on a test/development machine, before running on a production server.

Leave a Reply

Your email address will not be published. Required fields are marked *

CJayMead's SQL Server, Endeca, MS Office Help © 2018