Monitoring DBS activity in SQL

Question

Monitoring DBS activity in SQL

Michael Obershaw

SSC Enthusiast

Points: 105
More actions
August 14, 2005 at 10:17 am

#94583

Is there a method that can be established with the logging capabilities in SQL Server to capture all DBA activities in the database?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

maertean esaeasner Ten Centuries Points: 1162 More actions · Answer 1

You can use the profiler available with SQL. Log all the StmtCompleted::BatchCompleted statements and write it to a table... this will tell you all that has been executed by the dbo. See BOL for more details.

M