[dba-SQLServer] TRIGGER question

It is #Inserted not #Insert.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Harkins
Sent: July 11, 2005 9:24 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] TRIGGER question

I get the same error on #insert -- just can't seem to get this to work
Arthur. Is there perhaps some permission or something that I need to flag to
let me view data from these two tables? Or, perhaps it's a question of
timing? 

I have a simple insert/update trigger and at the end I put 

SELECT Count(*) from #insert

And it returned an invalid object error on #insert.

Susan H.