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.
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.
In addition, check users who has ALTER permission on the table
3 people are following this question.