Our development team is by policy not allowed to be an administrator on our sql server instance. This instance is for development and testing. I would like access to the sql server logs for this instance but you have to be an administrator to open these. Is there a stored procedure, or table, that the administrator can grant access to without giving me admin rights?
I was thinking if there was a sp_XXXX the admin could create a stored procedure that called that function using their own rights, and just grant us access to that. does anyone know if there is an sp, table, or system table where the logs are accessible?