Sample solution for DDL Triggers SQLChallenge (18 minutes)

Back to: Who Made That Schema Change? A DDL Trigger SQLChallenge (28 minutes) > Solution

1 Comment. Leave new

  • Awesome challenge. Just curious as to why you wouldn’t just use an ‘WITH EXECUTE AS ‘ clause on the trigger to avoid giving everyone write access to that audit table?

    Thanks

    Reply

Share a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Who Made That Schema Change? A DDL Trigger SQLChallenge (28 minutes)

Menu