AUDITING: SQL Server Object Changes

If you enable object monitoring within the RockSolid monitoring profile, by default all object changes (create, alter, drop) to objects will be logged as events within RockSolid.  This excludes temporary objects.

Viewing Object Changes

To view object change history in RockSolid, please go to the Events -> Search Event History page.  From this page select the relevant date range, and instance details as required.

Using the event type option please select:

  • Audit SQL - Object Creation : An event logged by RockSolid when objects are created
  • Audit SQL - Object Modified : An event logged by RockSolid when objects are modified
  • Audit SQL - Object Deleted : An event logged by RockSolid when objects are deleted

Hitting Search will return relevant modification records.  Each event shows the object, date/time and user making the modification.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.