AW: [dba-SQLServer]Trigger problem (update)

Michael Brosdorf michael.broesdorf at web.de
Thu Jul 17 10:08:06 CDT 2003


Just found out something even more strange:

that statement works just fine:

CREATE TRIGGER vueTest_Trig_D ON [dbo].[vueTest]
instead of delete
AS
raiserror ('Nonono!!',16,10)


But this one tells me, 'Invalid object name 'dbo.vueTest'':

CREATE TRIGGER vueTest_Trig_D ON [dbo].[vueTest]
For delete
AS
raiserror ('Nonono!!',16,10)
rollback transaction


AFAIK it should be possible to create a trigger on a view, or is it?

Michael


More information about the dba-SQLServer mailing list