question

rehaan avatar image
rehaan asked

Profiler

How to capture all DBA activities using Profiler? Can anyone help me with any script please? Thanks in advance
dbaprofilerextended-events
2 comments
10 |1200

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

Oleg avatar image Oleg commented ·
@rehaan What does "all DBA activities" mean? If it means the activities of a specific login (which happens to be a member of db\_owner role) then you can configure the profiler with the appropriate filter. Please take a look at the [similar question][1], there are some screenshots in the answer which might be helpful. [1]: https://ask.sqlservercentral.com/questions/146175/profiler.html
0 Likes 0 ·
rehaan avatar image rehaan commented ·
Hi Oleg, Thanks for your response as always and thanks for directing em to the link. I need to capture every activity on server of those users who has sysadmin permissions. Which template should I use to capture these activities(Just don't want to capture so much which is not required)Also want to capture nay login which tries to open the Certificate, asymetric key, symetric key for encrypting.
0 Likes 0 ·

0 Answers

·

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.