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