Trigger on a table in TempDB

Giganews Newsgroups
Subject: Trigger on a table in TempDB
Posted by:  Karthik (karthiksmil…
Date: 21 Aug 2006

I have an application that creates and makes use of a table in tempdb.
My problem is that I have a couple of triggers on this table that get
dropped everytime SQL Server restarts (due to the fact that tempdb gets
recreated). Is there a way to automatically recreate these triggers
each time SQL Server starts? It looks like it is not possible to have a
"create trigger" statement within a stored procedure. I would greatly
appreciate some ideas....thanks in advance!