MiguelSQL (11/16/2010)
There are many ways to skin a cat:
Indeed there are 🙂
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
And it looks like like the tempdb is created even sooner than the first process (at least it is on the couple of instances I tried). YMMV