Home Forums SQL Server 2005 Development monitor table and invoke stored procedure if any inserts happens in that table using notification service RE: monitor table and invoke stored procedure if any inserts happens in that table using notification service

  • November 5, 2008 at 10:56 am

    #894431

    Why not just create an After Insert trigger directly on the table. Why even deal with Service Broker?

    http://msdn.microsoft.com/en-us/library/aa258254(SQL.80).aspx

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]