AW: [dba-SQLServer]Trigger problem solved - new problem

Just found out myself: EM seems to process data on the underlying tables
directly, so the instead of trigger of the view never gets it's chance.

Specifying VIEW_METADATA in the view's definition solves that problem.

Does anyone have any experience if using that option has any influence if
the view is linked to an Access 2000 database as a linked table?


TIA,

Michael

-----Ursprungliche Nachricht-----
Von: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]Im Auftrag von
Michael Brosdorf
Gesendet: Donnerstag, 17. Juli 2003 17:08
An: dba-sqlserver at databaseadvisors.com
Betreff: AW: [dba-SQLServer]Trigger problem (update)


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
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com