Invalid object name 'updated' error on trigger

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Invalid object name 'updated' error on trigger

Author

Topic

CoffeeAddict
Yak Posting Veteran

94 Posts

Posted - 2009-08-18 : 11:50:58

I am not sure why this trigger is causing an error.

I get an error when trying to update some data in this table:

update Page
set useDefaultBar = 1
where Page.id = 1

ALTER TRIGGER [dbo].[Page_Trigger]
ON [dbo].[Page]
FOR UPDATE, INSERT, DELETE
AS
Insert Into WebCache (dataID, dataTable)
select updated.id, 'page' from updated

Insert Into WebCache (dataID, dataTable)
select inserted.id, 'page' from inserted

Insert Into WebCache (dataID, dataTable)
select deleted.id, 'page' from deleted

Error:

Msg 208, Level 16, State 1, Procedure Page_Trigger, Line 5
Invalid object name 'updated'.

CoffeeAddict
Yak Posting Veteran

94 Posts

Posted - 2009-08-18 : 11:54:11

nevermind, there is no "updated" on a trigger.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources