question

@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

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.