Press "Enter" to skip to content

Error Tracking with Extended Events

Kenneth Fisher performs some diagnostics:

Dev: We are getting an error: SELECT permission was denied on the object MyObject.
Me: Ok, what instance, database, and account is getting the error?
Dev: The instance is InstanceA and we think the database is DatabaseA but we have no idea what the service account is.

Now, watch this.

Watch and learn.