• you can get the time by running this query also

    Select name,crdate from sys.sysdatabases where name='tempdb'