Reputation: 1590
Find a procedure or table by name in SQL Server
A month or so ago I somehow managed to get a tiny widget showing in SQL Server 2008 where I could type the name of the procedure/table (never searched for anything else) and it would bring a list of matching items. I could then right click on the one I wanted -> Click (I believe) "synchronize" and it would bring the said item in the Object explorer, from where I could do whatever.
The widget I'm looking for was part of SQL Server and i was able to pin it bellow the Object Explorer.
I've no idea how I found it and where it is, but it's extremely useful for fast searching of objects.
It was NOT a Select or an SQL statement of any kind.
Upvotes: 2
Views: 63
Answers (3)
Reputation: 6719
Use the 'Object Explorer Details' window (F7).
SSMS -> View - > Object Explorer Details
Upvotes: 1
Reputation: 9249
The SSMSBoost add-in also provides such functionality.
Maybe some screenhots are helping to remember...
As already mentioned by Creep, it could also be RedGate SQL Search:
Upvotes: 3
Reputation: 310
I think it could be one of those (free) products : redgate sql search or dbforge sql search
Upvotes: 1
Related Questions
- Find all stored procedures that reference a specific column in some table
- Find the stored procedure which uses a particular table in sql server
- Find stored procedure by name
- Search a procedure in SQL Server
- How to find the name of stored procedure, based on table name search, using SQL Server 2008?
- How to get the all table(s) name which are used in particular stored procedure?
- How to find all stored procedures and table from a single stored procedure?
- Find database name from the stored procedure name
- How to find stored procedures by name?
- Query to locate stored procedures by Prefix