Solved

Description of MS Stored Procedures

Posted on 2010-09-14
4
178 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
  • 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 39

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
OPENDATASOURCE 8 35
SQL Server; storing data in offline mode. 10 67
sql sERVER PARSE DATA BY HOURS AND COLUMNS 2 42
Compare data between two databases 16 95
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

914 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now