SQL 2005 exclude system stored procedures

Is there a feature you'd like us to add? Post it here.

SQL 2005 exclude system stored procedures

Postby mgnoonan on Thu Feb 01, 2007 8:00 pm

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.
Matt Noonan
EasyObjects.NET - The O/RM for the Enterprise Library
http://www.easyobjects.net
User avatar
mgnoonan
Expert
 
Posts: 1019
Joined: Tue Sep 14, 2004 3:17 am
Location: Springboro, OH

Postby mike.griffin on Sat Feb 03, 2007 8:48 pm

Okay Matt, that should be an easy one, we'll sneak that in the next release.
User avatar
mike.griffin
Site Admin
 
Posts: 3290
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN

RE: SQL 2005 exclude system stored procedures

Postby n8wei on Thu Mar 22, 2007 4:42 pm

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.
User avatar
n8wei
Lurker
 
Posts: 9
Joined: Wed Jul 19, 2006 1:35 pm


Return to Enhancements

Who is online

Users browsing this forum: No registered users and 1 guest