Find creator of SQL Server trigger

Sunny Singh 1 Reputation point

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,221 Reputation points

    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

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

    0 comments No comments