List of Stored Procedures 1

[jorbroni]

Hi

Can anyone tell me how do I generate a list of the stored procedures in a database?

Thanks

 

[JohnDTampaBay]

This should do the trick in SQL2K:

SELECT Specific_Name
FROM Information_Schema.Routines

Check Information Schema views in BOL for more info.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[BuGlen]

Try this:

select * from sysobjects
where xtype = 'p'

- Glen

Know thy data.

 

[JohnDTampaBay]

Microsoft cautions against querying the system tables directly. They have been threatening to change the structures, etc., on us for a while now. They contend that the Information_Schema views will not change, making them a safer choice. There are also many metadata functions available to get information on database objects. Just my two cents.

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[BuGlen]

Hi Angel,

That's definately good to know. I'll have to look into the schema views.

BTW: Where it Tampa? I live in Tampa and work in St. Pete.

- Glen

Know thy data.

 

[JohnDTampaBay]

I live in West Palm Beach (WPB) right now and will be moving to Tampa Bay (actually St Pete/Gulfport area) in early March 2004. Happy coding!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.