CODEWITHSUNDEEP
sql-server
juniorDev
juniorDev

Reputation: 155

Trigger Disable User

I have a problem and question. The SQL trigger in my SQL Server has been disabled. And I want to learn who disable this triger. Is there any way to get username who disable MSSQL trigger? By SQL query or like that? Regards.

Upvotes: 0

Views: 139

Answers (1)

shibormot
shibormot

Reputation: 1638

If you have sql server audit up and running then you can get that information. Otherwise no. Also read article Auditing when Triggers are Disabled or Enabled for SQL Server

Upvotes: 2

Related Questions