Michael Brosdorf
michael.broesdorf at web.de
Thu Jul 17 09:56:31 CDT 2003
Dear group, I have a strange problem with a trigger on a view. The trigger is an instead of trigger for deletes. If I work with the view/table from within my application or SQL Analyzer, everything works fine (in that case, deletes through the view are cancelled). But, if I open the view in the Enterprise Manager, I can delete rows from the view. Now, that makes me think that something is not set up right... Here are the scripts: CREATE TABLE [Table1] ( [Test_ID] [int] NULL ) ON [PRIMARY] GO INSERT INTO Table1 values(1) INSERT INTO Table1 values(2) INSERT INTO Table1 values(3) CREATE VIEW dbo.vueTest AS SELECT * FROM dbo.Table1 CREATE TRIGGER [vueTest_Trig_D] ON vueTest INSTEAD OF DELETE AS raiserror ('Nonono!!',16,10) Any ideas? Michael