Problem One of the things that DBAs need to be aware of is the permissions that are granted at the server level and at the database level. Using Enterprise Manager or Management Studio it is pretty easy to look at one object at a time, but what if you want to look at permissions you have granted across the board. Pointing and clicking is not so bad if you have a couple of objects to look at, but most instances of SQL Server have several layers of permissions that are granted. So what is the best way to get an overall look at your permissions that have been set?
Solution The simplest approach is to use the stored procedures that Microsoft has included with the database engine. A lot of these same procedures are called when use the GUI, but instead of showing you data one object at a time you can take a look across your server or across your database.
Here is a list of some of these useful commands, what they do and sample output from each command.