SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
395 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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