Post reply

How to select user stored procedures

  • March 21, 2006 at 1:15 pm

    #111489

    Hi, I'm trying to write a query to select all user stored procedures in a db (and exclude system stored procedures). The follow query will list all stored procedures (user and system). How can I exclude the system stored procedures?

    select * from sysobjects where type='P'

    Thanks.

  • March 21, 2006 at 1:54 pm

    #627968

    I'm not sure if this is always the case, but it seems like the category column in sysobjects has a 2 for system sprocs and a 0 for user sprocs.

    So long, and thanks for all the fish,

    shang
    atk.com

  • March 22, 2006 at 5:34 am

    #628057

    Yes, that's it. I overlooked that column. Thanks and sorry for such a basic question!

  • March 23, 2006 at 7:30 am

    #628338

    Just a note - standardized naming conventions also help!







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply