stored procedures in a database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » stored procedures in a database

stored procedures in a database

Rate Topic

Display Mode

Topic Options

Author

Message

sandhyarao49

Posted Saturday, August 09, 2008 10:11 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650

Hi to all,

I have a small doubt.
If we want to know the see all the tables in a database we normally use sp_tables.I want to see all the stored procedures ina database. how we can see all the stored procedures in a database.

Thanks,
sandhya

Post #549824

RBarryYoung

Posted Saturday, August 09, 2008 10:59 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

Select * from sys,procedures

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #549827

Steve Jones - SSC Editor

Posted Sunday, August 10, 2008 5:00 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:14 PM
Points: 31,421, Visits: 13,734

I'd recommend select * from information_schema.routines

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #549927

Jack Corbett

Posted Sunday, August 10, 2008 6:35 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

Either of the other suggestions will work, but I would agree with Steve because INFORMATION_SCHEMA is an ANSI standard while sys.procedures is a Microsoft view that could be deprecated or changed.

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #549956

RBarryYoung

Posted Sunday, August 10, 2008 6:56 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

Steve Jones - Editor (8/10/2008)

I'd recommend select * from information_schema.routines

Oh yeah, I forgot about this one. I like it much better.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #549958

Arifresume

Posted Friday, May 17, 2013 6:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 17, 2013 10:11 AM
Points: 1, Visits: 6

You can use below query:

sp_stored_procedures. Just try it once.

Thanks,
Arif.

Post #1453959

« Prev Topic | Next Topic »

Permissions