Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Philippines
    Posts
    2

    Smile Unanswered: Notify Application.

    Hello,

    What is a better way of notifying applications that
    is connected to a SQL DB that a certain table has been updated (New records added) by another application which connected to the same
    database?

    Am thinking of executing a COM through sp_OACreate
    from a table trigger to do the notification. Is this sufficient?


    Raymond

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Check Lumigent's latest notification software for schema changes, its free.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •