repost: SqlServer 2005 => SMS => Object Explorer => Programability Filter questio

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_%'
)
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
"frostbb" <barry.b.frost@.remove-this-spam-filter.state.or.us> wrote in message news:%23tuas6o$GHA.4024@.TK2MSFTNGP04.phx.gbl...
> 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_%'
)
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
"frostbb" <barry.b.frost@.remove-this-spam-filter.state.or.us> wrote in message news:%23tuas6o$GHA.4024@.TK2MSFTNGP04.phx.gbl...
> 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
>
|||frostbb (barry.b.frost@.remove-this-spam-filter.state.or.us) writes:
> 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_ ?
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 Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|||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
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns986FEE338BC11Yazorman@.127.0.0.1...
> 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 Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx