Last post Dec 26, 2017 03:33 PM by wmec
Dec 19, 2017 08:05 PM|skeeneyman|LINK
I can't seem to figure this out.
I have a fairly complicated view (SNP.dbo.View_OS) that gets data from several tables in another database (I'll Call it OS) that I do NOT have permission to update.
When OS's data updates the SNP.dbo.View_OS displays the OS's updated data.
What I need is a way to tell when SNP.dbo.View_OS's data changes (based on changes in OS) and it trigger another table (SNP.dbo.Table_1) in the SNP Database to reflect those updates.
At first, I thought this would be easy using an INSTEAD OF UPDATE trigger but if I'm understanding these triggers correctly using instead of triggers requires that I UPDATE the SNP.dbo.View_OS view which would update data
in the OS database which I am NOT allowed to do. Also, I can NOT add a trigger to any of the tables within the OS database which is where the SNP.dbo.View_OS view data is coming from.
Dec 25, 2017 01:31 AM|AngelinaJolie|LINK
Sir, it seems that there is no good way as far as I know;
The walkaround that we do something when we CURD the several tables:
With regards, Angelina Jolie
Dec 26, 2017 03:33 PM|wmec|LINK
The change of view column means there is change to original table, right? Then you can create insert/update trigger on original table to detect such change.