a list of SP organized by task

[KCWMS]

Is there a reference that list SYSTEM SP logically as opposed to alpha?

I spent too much time today trying to figure out which sp would return a list of databases to which a particular login has access (like the list you see in the Database Access tab of the Login Properties dialog box).

I shouldn't have to come to this forum or google to find info that is simply buried in the BOL... but I usually do.

Thanks in advance

 

[NoCoolHandle]

No..

However you might want to look up informationschema views..

My guess is that there might be a few there that could help you.

Personaly I tend to just query the system tables to get the data I need. But if you do a search in sysobjects in the master database where name like '%login%' and type = 'p' you will get all sp_'s related to logins.

For what it is worth (very little i suspect)


Rob