SQL Server 2008 Improvements Practicals – Object Search

I gave a presentation at TechEd 2008 where I covered our new features in "A Day in the Life of a DBA". Here's more of what I showed for 1:00pm - "New and Shiny":

Sometimes it can be, well, a bit challenging to locate the objects you want to work on in SQL Server Management Studio (SSMS). You have to remember where the object is, and then drill down to find it. That can be a bit of a pain.
But with SQL Server 2008 SSMS, you can now click on a database or database object, and then look in the top right-hand corner of the Object Explorer Details (OED) pane. If you don’t see OED, just press F7 (we put that hotkey in as well).  You’ll see a “Search” box – type in the name of the object, or even part of it using standard T-SQL wildcards like % and then hit the ENTER key. The object will be located, and you can right-click it to get a limited menu, or select “Synchronize” to get the full right-click menu. The interesting thing is that the search is cross-type – meaning that if you type in buck% you’ll get all of the objects that start with “buck”, no matter what they are.

One final note – if you select an Instance instead of a database, you’ll search all databases. This could take a while, but it can be a lifesaver. Also, you always have the “cancel” button.

Comments (2)
  1. jackbond says:

    What would be really sweet would be full SQL or LINQ queries, i.e.

    SELECT * where name like ‘M%’ and Type=’Table’


    from z in objects where z.Name.StartsWith("M") && z.Type.ToString() == "Table"

Comments are closed.

Skip to main content