question

desertsunny29x avatar image
0 Votes"
desertsunny29x asked ·

Find creator of SQL Server trigger

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.

azure-sql-virtual-machines
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DanGuzman avatar image
0 Votes"
DanGuzman answered ·

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.

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

UriDimant avatar image
0 Votes"
UriDimant answered ·

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

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.