I am using SQL Server 2005 Express Management Studio. I want to put in
multiple filters for stored procedure. Example: where sp name contains
'spFNP or spNGFM'. Is this possible? If so, what is the syntax?

Also, is there a way to save filter between sessions?

Unfortunately, it appears that you cannot.

If you are trying to obtain a list of all stored procedures that have certain characters in their name, you might try a query like this:

SELECT [name]
FROM sys.procedures
WHERE ( [name] LIKE 'spFNP%'
OR [name] LIKE 'spNGRM%'
)

--
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


"Todd" <Todd (AT) discussions (DOT) microsoft.com> wrote

That would be taking step back toward stone age. What is the point of nice
UI if not very useful?

"Arnie Rowland" wrote:

Sorry you feel that way. In fact, most 'professionals' that regularly work
with SQL Server (and Oracle, etc.) do NOT use the "nice UI" for queries.

The best way to query the database is to know how to query the database and
not rely upon a GUI.

--
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


"Todd" <Todd (AT) discussions (DOT) microsoft.com> wrote

Sorry, we can't all be 'professionals' like you. MS went to the trouble to
build Express version for us developers who would rather have UI instead.
Just because you would rather type:

SELECT [name]
FROM sys.procedures
WHERE ( [name] LIKE 'spFNP%'
OR [name] LIKE 'spNGRM%')

.... I would prefer to only type 'spFNP;spNGRM' in a textbox, doesn't make me
less 'professional'. Just more efficient. My time is valuable. I could
write .Net in Notepad too, but would defeat the purpose of Visual Studio.

MS - Please add support for multiple filters in next version for us folks
who want easy way out.
"Arnie Rowland" wrote:

Post your suggestions for SQL Server here:

Suggestions for SQL Server

http://connect.microsoft.com/sqlserver


--
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


"Todd" <Todd (AT) discussions (DOT) microsoft.com> wrote

"Professional" is finding ways to work with the tools you have instead of
bemoaning that the tools you want aren't available.

"Professional" is working to improve the product by offering suggestions.

Please post your suggestion for product improvement.

--
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


"Todd" <Todd (AT) discussions (DOT) microsoft.com> wrote