SQL Trace Error

by Jul 18, 2014

I have the agent deployed to a SQL error I am monitoring, I’ve tried to collect the data to see what audit information has been captured.

SQLcompliance agent is throwing up application event errors, I think it’s something to do with accessing a stored procedure that doesn’t exist.

“You cannot create procedures on MASTER – DBA must disable trigger “NoCreateProcs” to do this!”

“Error: An error occured setting stored procedure permissions. Name = sp_SQLcompliance_StartUp.
Exception: Cannot find the object ‘sp_SQLcompliance_StartUp’, because it does not exist or you do not have permission.”

We are on version 4.2.204.0 of the agent and software.

I can see an agent trace files folder on the monitored server.