tsql - SQL Server 2005: T-SQL to query when a database was last restored? -

Is it possible to use T-SQL alone? Which queries would you write against system tables?

Use restore history in the restorehistory table msdb database.

  Select from MAX (restore_date) msdb.dbo.restorehistory WHERE destination_database_name = 'SomeDB'