Post reply

New / changed / deleted record detection without a trigger in the host db?

  • November 23, 2005 at 5:31 am

    #166654

    Is there a clever way to detect that a new row has been added to a table without using a trigger which resides in that table's db?

    My app has select only permissions on a database; someone else will be deleting, updating and inserting. When these things happen in some tables I would like the app to be able to respond. If I could add trigger to the database I would, but I can't change anything structural.

    Can you have a trigger in one db that responds to events in another:

    CREATE TRIGGER [TRIGGER NAME] ON [dbname].[dbo].[tablename] ?

    I also considered creating a remote view on the table and then a trigger on the view, but then had a Doh! moment and realised that the trigger on the view would respond only to view events, not event on the underlying table.

    Furthermore, the app will be connecting with ADO.Net so is there some way of using a dynamic, always connected dataset and detecting changes to that?

    Thanks in advance, o gurus,

     

    Bill.

  • November 23, 2005 at 12:54 pm

    #605541

    If you can't change anything the only posible other way is so cumbersome that I'd rather tell you that there is not other way

    Cheers,


    * Noel

  • November 29, 2005 at 1:22 pm

    #606532

    Bring on the pain o wise one!  i have a similar issue, a COTS package that must remain pure, and i need to see who's making certain changes

  • November 29, 2005 at 1:29 pm

    #606535

    if you don't or can't use triggers but can shed some $$ have a look at idera SQL Compliance Manager and if you have $$$$$ then have a look at lumingent Entegra

     


    * Noel

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply