Solved

Description of MS Stored Procedures

Posted on 2010-09-14
4
200 Views
Last Modified: 2012-08-06
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
 
0
Comment
Question by:lou_ak
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 33675443
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
 

Author Comment

by:lou_ak
ID: 33684795
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
 
LVL 40

Accepted Solution

by:
lcohan earned 250 total points
ID: 37096646
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
 

Author Closing Comment

by:lou_ak
ID: 38261249
ok
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SQL order by with "over" statement and row_number() 11 55
Grid querry results 41 82
Query to return total 6 24
Find unused columns in a table 12 68
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question