Referring to User Created Stored Procedures

[AccessSQLUser]

If I wanted to get a list of stored procedures, excluding the system ones, how would I do this?

 

[tlbroadbent]

I can't find documentation to confirm this but it appears that system procedures have status < 0 and category = 2. To identify user procedures you could query sysobjects as follows.

Select Name, Satus, Category
From sysobjects Where status>=0

NOTE: All system tables are subject to change and the query may not work in future releases. Terry

http://members.home.net/tlbroadbent/index.htm

 

[Andel]

You might want to add &quot;type = p&quot; to select stored procedure only...

Select Name, Status, Category
From sysobjects Where status>=0 and
Type = 'P'
Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[AccessSQLUser]

Thanks to both of you