You can use the @DEBUG parameter with most procedures if additional logging is necessary.
Depending on the procedure, this can result in a very verbose execution that contains state change information and call stack details and other background call details to assist with debugging certain issues.
@DEBUG = 'YES'