Post reply

Monitoring DBS activity in SQL

  • 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?

  • August 15, 2005 at 6:39 am

    #582111

    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

     

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

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