How can I track sql scripts executed against with SA login SQL server?

Question

How can I track sql scripts executed against with SA login SQL server? currently we are using extended events to track these, do we have any alternative methods?

Answer 1

Hi @Lakshmi kiran Vennapusa

Currently no direct way as such to track sql Scripts executed against any login.
Let me explore some option if from SSMS.

(Please don’t forget to "Accept the answer" & “up-vote” , this can be beneficial to other members. Thank You)

Regards,
J.D.

Answer 2

Hi @Lakshmi kiran Vennapusa ,

Thank you so much for posting here in Microsoft Q&A.

Please have a try with below methods and hope any of them could be helpful to you.

1. SQL Server Profiler
2. Create a trigger
3. SQL Server Audit (Database Engine)
4. User_defined Procedure

Best regards
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.