Find creator of SQL Server trigger

Sunny Singh 1 Reputation point
2020-02-06T15:39:44.863+00:00

I am a SQL Server sysadmin. Someone created a trigger in a table of the database "msdb".
Now how can I find who has created that trigger?
Let me know the SQL query or some other trick.

SQL Server on Azure Virtual Machines
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Dan Guzman 9,206 Reputation points
    2020-02-07T02:52:18.03+00:00

    The information may still be in the default trace if the trigger was created recently. The schema change report can be accessed from SSMS Object Explorer with a right-click on the instance. Select Reports-->Standard Reports-->Schema Change History.

    0 comments No comments

  2. Uri Dimant 206 Reputation points
    2020-06-11T04:37:48.16+00:00

    In addition, check users who has ALTER permission on the table

    0 comments No comments