How can we help you today? How can we help you today?

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

jonathan.lee
0

Comments

2 comments

Sort by
  • Alex B
    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
    Alex B
    0
  • Pete_Ruiz

    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



    Pete_Ruiz
    0

Add comment

Please sign in to leave a comment.