Audit stored procedure calls with parameter values

• Michael Wasson

  Mr or Mrs. 500

  Points: 528

  More actions

  February 27, 2018 at 2:49 pm

  #336347

  I am using a Database Audit Specification with the "EXECUTE" Action ID to monitor calls to a stored proc.  My stored proc is usually called from another stored proc.  Works great for the static values that are passed to the stored procedure, however it just outputs variable names and not variable values.  (see example below)  Is there a way to get all the parameter values?

  Object Name    USP_MaxCheckTimeHistory_Insert
  Statement        EXEC [USP_MaxCheckTimeHistory_Insert]
                                  @LocationID = @oldOutOfCellId,
                                  @BookingNbr = @currentBookingNumber,
                                  @OfficerNbr = NULL,
                                  @MaxCheckTime = @UserMaxCheckTime,
                                  @IsAutoPause = 0,
                                  @UseOutOfCellLog = 1,
                                      @IsHazard = 0,
                                      @Source = 'InmateUpdateHazardsOnMoved - 9'