question

Sagar_Thakur avatar image
Sagar_Thakur asked

How to store command details that has been run through SSMS

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.

dbasqlserver
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
anthony.green avatar image
anthony.green answered

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

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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