SQL 2005 exclude system stored procedures

[mgnoonan]

When connecting to a SQL Server 2005 or SQLExpress database, the list of stored procedures contains both user created and system stored procs. Would be nice to just see the user stored procs in the list (as it is in SQL 2000), if it is possible to differentiate between the two kinds.

[mike.griffin]

Okay Matt, that should be an easy one, we'll sneak that in the next release.

[n8wei]

Hey Mike,

Did you guys ever implement this? I have a couple of other quirks both with SQL 2000 and SQL 2005 that are along these same lines...

1. I can't differentiate between stored procedures and user defined functions to provide only stored procedures in the list, in the GUI.

2. I have an add-in which parses out the ProcedureText of MSSQL stored procedures in order to populate User Meta Data with any default values found for the parameters. That add-in basically scans through all of the procedures in the database and I'd like to be able to skip any system stored procs, user defined functions, etc.