|Subject:||Trigger on a table in TempDB|
|Posted by:||Karthik (karthiksmil…@gmail.com)|
|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!