Create trigger on view failed

[theresatan]

I want to create a trigger on a view for insert, but I got a message said 'Invalid object name'. I can select from this view. Followings are my scripts and error message:
(run on SQL 2000)
create table t1 (c1 char (10) NULL )
create view vt as select * from t1
create table log1 (c1 datetime NULL )

create trigger tr1 ON t1
for insert
AS
insert into log1 values (getdate())
----------all above succeed
create trigger tr2 ON vt
for insert
AS
insert into log1 values (getdate())

Server: Msg 208, Level 16, State 4, Procedure tr1, Line 1
Invalid object name 'vt'.

Thanks!

Theresa

[skhanal]

You can only create INSTEAD OF trigger on a view.

create trigger tr2 ON vt
INSTEAD OF insert
AS
insert into log1 values (getdate())

[theresatan]

Thanks skhanal!

It works.

Theresa