Shane O’Neill diagnoses a permissions issue with XML Schema Collections…or is it?
In my head I’m thinking of all the things that I can do to try and troubleshoot this problem.
- Extended Events my session,
- Ask my Senior DBA,
- Cry
Then I realize that I’m jumping the gun again and I slow down, and check the first error message again. This time without the developers shouting in my ear, about permissions.
This is a great example of why it’s important to troubleshoot using a methodical, logical process. If you get it stuck in your head that the answer is quite obviously something, you lose a bunch of time if it turns out that it isn’t quite as obvious.