How to store command details that has been run through SSMS

Question

Question by Sagar_Thakur · Nov 28, 2020 at 02:53 PM · dba sqlserver

I am trying to store command logs that has been run through SSMS in SQL Server 2018. I do not know how to store. Please help me.

0

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2020-11-30T08:58:21Z

Answer by anthony.green · Nov 30, 2020 at 08:58 AM

Server Audit/Database Audit

Extended Events

Server Side Trace

Each has their own pros and cons, investigate each option and implement the one which meets the needs

0 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.