SELECT in trigger (BP003) rule firing incorrectly

jonathan.leejonathan.lee Posts: 4 Bronze 2
in SQL Prompt
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

Tagged:
· Share on Twitter

Answers

  • Alex BAlex B Posts: 1,158 Diamond 4
    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?
    · Share on Twitter
  • Pete_RuizPete_Ruiz Posts: 123 Silver 4

    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



    · Share on Twitter
Sign In or Register to comment.