Query the name of user that created a trigger

How can I query the name of the user that created a trigger?
Who is Participating?
rboyd56Connect With a Mentor Commented:
All you can do is query the owner of the trigger.

You can use sp_helptrigger to find the owner of the trigger.

In many cases the owner of the trigger is the same as the one who created it.
But this is not always the case. If a member of the db_owner role creates a trigger it could be owned by dbo but not actually created by the dbo of the database.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.