If you are facing an issue of unauthorized index modification, you can use a very simple trick discussed in this blog post.
Code used in Video: https://blog.sqlauthority.com/2021/08...
Subscribe for Free Performance Tuning Scripts: https://go.sqlauthority.com/
0:00 Intro
00:15 Real-world Scenario
00:40 Demo: Unauthorized Index Modifications
01:35 Demo: Database Trigger
02:17 Final Say
#SQLServer #PerformanceTuning #SQLAuthority