SELECT in trigger (BP003) rule firing incorrectly

SELECT in trigger (BP003) incorrectly fires for a SELECT statement in a trigger that is attached to a cursor.

ALTER TRIGGER xxxx ON yyy.YYYYYY
....
    DECLARE cur_updated CURSOR LOCAL FAST_FORWARD FOR
    SELECT
      Inserted.*   -- Actual column list here.  Star only shown for brevity/non-specific example.
    FROM inserted
....
GO

Answers

  • Hello @jonathan.lee

    This is actually a known issue with internal reference SP-7127 that hasn't yet been resolved. I've put a reference to this post there and we will update you if we get any movement on this.

    Sorry for any inconvenience this might have caused!

    Kind regards, 
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • Hello @jonathan.lee,

    This is an update for SP-7127. The team have just released a fix for this issue in SQL Prompt 9.4.7. Please update to this version and confirm that the issue has been corrected for yourself as well!

    Kind regards,

    Pete Ruiz



Sign In or Register to comment.