[dba-SQLServer] trigger help

HAPPY BIRTHDAY!!!!!!! 

Why are you on the computer????? :) This may be an Express problem, but I
wanted to check first. I do remember having this problem with SQL Server 200
in the Query Analyzer -- but I don't remember how I eventually resolved it.
The problem may not have been the temp table at all -- I just don't
remember. 

The problem is that I can't create the trigger. 

I'm going to create a temp inserted table and see if that keeps MS from
throwing this particular error -- if it does, as David suggested -- it's a
workaround. I just want to make sure it's necessary and not some silly
mistake or assumption I'm making. 

Susan H. 


The table exists within the life time of the trigger. 

Try it using query analyser and see if it works. Its my birthday party now
so if it dosnt work give me a shout and I will check in the morning.

U sure this isn't  an sql express issue not a trigger issue?