There are many ways to skin a cat:

This is my way:

select crdate,[Name] from sys.sysdatabases where name = 'tempdb'

Why does this work?

Well... every time you MSSQL Starts, it recreates the TEMPDB.

🙂

Miguel