I was needing to get an idea of the permissions that had been granted in a couple of databases the other day, and being the GUI novice I am, couldn't find what I wanted easy enough (if it even is in there.)  So, I hunted around in the system views to see what I could find.  There are two views of major interest ...

This is the second time I have needed this, so that elevates it to blog status (code for mine and your reuse being the second most important reason I blog.  The most important one is the notoriety, glamour, and big bucks :) I have a database that I have recently needed to check to discover if data existed in them, and in some cases, ...