Description of MS Stored Procedures

Hi,
i ran a query to determine what type of permissions the public role has on objects. i discovered it has execute permission on over 1000 stored procedures.

Is there some way to get a description of each of the stored procedures so i can ascertain if execute permission is really required on all the SPs?

thanks
 
lou_akAsked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
You can get a list of all system stored procs by running:

select * from master.sys.all_objects where type_desc like '%procedure%'

And if Microsoft would have populated the descriptions for those from here:
select * from sys.extended_properties

Or here:
select * from master.sys.fn_listextendedproperty(default, default, default, default, default, default, default);

0
 
BrandonGalderisiCommented:
The only way that a description would be there is of someone documented the procedures with MS_Description or added code comments.  Either way, SQL Server can't tell you "what a procedure does".  You need to tell it what it does.
0
 
lou_akAuthor Commented:
Hi Brandon,

what i'm actually looking for is a document that contains a list of SPs that come by default and a description of what they do. I've looked at this site http://msdn.microsoft.com/en-us/library/ms187961.aspx, the problem is i'll have to go back and forth quite a bit. Any help will be appreciated.
0
 
lou_akAuthor Commented:
ok
0
All Courses

From novice to tech pro — start learning today.