SqlServer 2005 => SMS => Object Explorer => Programability Filter => Filter:
Contains _aaa_  shows all stored procs that include the string _aaa_,  works
great.

SqlServer 2005 => SMS => Object Explorer => Programability Filter => Filter:
Contains _yyy_  shows all stored procs that include the string _yyy_

How does one structure the "contains" filter to show procs that contain both
_aaa_ AND _yyy_  ??

Still don't have a good feeling for Sql Server tools expressions.

Any help would be greatly appreciated !!!

Barry
in Oregon

I don't think that there is any way to combine filter criteria.

You could execute the following query:

SELECT ROUTINE_NAME
FROM   INFORMATION_SCHEMA.ROUTINES
WHERE (  ROUTINE_NAME LIKE '%_aaa_%'
      OR ROUTINE_NAME LIKE '%_yyy_%'
       )

Show quoteHide quote

I don't think that there is any way to combine filter criteria.

You could execute the following query:

SELECT ROUTINE_NAME
FROM   INFORMATION_SCHEMA.ROUTINES
WHERE (  ROUTINE_NAME LIKE '%_aaa_%'
      OR ROUTINE_NAME LIKE '%_yyy_%'
       )

Show quoteHide quote

Arnie,

Thanks for the feedback.    Its very much appreciated!   Apologies for the unprompt acknowledgement.

Your EXAMPLE IS AWSOME !!  I've been 100% focused toward our migration since we 'spun up' sql server so I'm afraid I've only learned the absolutely necessary DBA tricks thus far.   Any insight into the sys tables without having to spend hrs sorting thru the MS BOL verbage is VERY MUCH APPRECIATED !!   I really, really wish MS would realize that 1 simple, 'to the point' example like yours is worth literally hundreds of words of BOL. !!  :)

BTW.  I've got a couple hundred stored procs (so far) and the filter is becoming more and more handy. (we've been migrating our two 'largest' enterprise db's from UNIX to Sql Server). I name our table management procs to sort by sub-system / table_name. I also have a number of 'generic tool box' procs that are accessed by multiple subsystems ... thus the need to display both _aaa_ and _yyy_ subsystem procs.

Best wishes and thanks again.

Barry
in Oregon

  I don't think that there is any way to combine filter criteria.

  You could execute the following query:

  SELECT ROUTINE_NAME
  FROM   INFORMATION_SCHEMA.ROUTINES
  WHERE (  ROUTINE_NAME LIKE '%_aaa_%'
        OR ROUTINE_NAME LIKE '%_yyy_%'
         )

  --
  Arnie Rowland, Ph.D.
  Westwood Consulting, Inc

  Most good judgment comes from experience.
  Most experience comes from bad judgment.
  - Anonymous

  You can't help someone get up a hill without getting a little closer to the top yourself.
  - H. Norman Schwarzkopf


Show quoteHide quote

frostbb (barry.b.frost@remove-this-spam-filter.state.or.us) writes:
I thought that maybe something like [xy]{xy][xy] would take you half-way
there, but it was too smart for me and escaped the brackets.

If you feel that this would be a valueable feature, pay a visit to
https://connect.microsoft.com/SQLServer/feedback/.

Erland,

Thanks for the feedback.  Its very much appreciated!  Also, apologies for
the late acknowledgement.

Good suggestion.  I'll ping MS about the issue
https://connect.microsoft.com/SQLServer/feedback/.

I've got a couple hundred stored procs (so far) and the filter is becoming
more and more handy. (we've been migrating our two 'largest' enterprise db's
from UNIX to Sql Server). I name our table management procs to sort by
sub-system / table_name. I also have a number of 'generic tool box' procs
that are accessed by multiple subsystems ... thus the need to display both
_aaa_ and _yyy_ subsystem procs at the same time.

Best Wishes!

Barry
in Oregon

Show quoteHide quote

SQL Server 2000: Stored Procedure to tell file size & free space
Query Analyser - output SQL commands to Results pane
Syntax coloring: SERVICE
Database Restore Error
Can not save relationship