What the? Where did THAT go?

Question

Post reply

What the? Where did THAT go?

Jeff Moden

SSC Guru

Points: 1004372
More actions
December 14, 2007 at 7:19 pm

#121498

In SQL Server 2000, in Query Analyzer, you could press the {F4} key and a wonder little search tool would come up (called "Object Search" in the 2k BOL shortcut-keys documentation). Whether you've instantiated the 2k5 or the 2k keyboard in 2k5, all you get is a cruddy properties window.
Where is that wonderful little "Object Search" window in 2k5 or did they take that out?
Thanks folks...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 1

it's gone - it's been replaced by the filter in object browser.

However - all is not lost... Here's a neat little trick...

http://www.codeproject.com/KB/database/SqlObjectSearch.aspx?print=true

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

of course - leave it to a C# programmer to re-rewrite the form, when he gives you the simplest solution in the first paragraph of his description (i.e. run query analyzer and connect to SQL 2005)....

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Jeff Moden SSC Guru Points: 1004372 More actions · Answer 3

Thanks, Matt... I was afraid you were going to say that... yet another highly useful tool shot into the bit-bucket by the idiots that designed the interface for 2k5. The article you referred me to is perfect and much appreciated.

As a side bar, it's funny and, maybe, even a little ironic... we all know about the risk of using undocumented features because they might go away... but even the documented features aren't safe.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 4

It's a strange combination. Yesterday I found myself accessing a 2005 server through QA (looking for stuff as you just were), and doing a lot of modification to sql2000 through SQL2005's SSMS (since it allows me to save my alter statement directly into my project to be uploaded to VS)....go figure.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Jeff Moden SSC Guru Points: 1004372 More actions · Answer 5

Heh... yeah... it's a shame that MS can't figure out the best of both worlds. Having just seen 2k5 for the first time and the apparent mess they made of the GUI interface, I cringe to think of the horror that may appear in 2k8. I love paying extra for GUI pretification and loosing functionality at the same time. Kinda like buying a new car only to find out your favorite cup no longer fits the holders and the only way to turn off the lights at night is to shut the vehicle down or press some unique combination of non-intuitive buttons (dome light override 4 times within 2 seconds on GMC Trucks), but the "daylights" turn on only if you take the vehicle out of park.

... and people actually get paid to design such crap. Like you said, go figure...

Hey! Have a great holiday season, Matt! Same goes to anyone who reads this!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Eddie Wuerch SSChampion Points: 12535 More actions · Answer 6

They probably asked around and realized that a lot of folks, like me, never used the object search. I played with it a few times back in 2001, then never used it again. I do so many other things in T-SQL that the few times I search for objects, I write a quick query against the system tables (2000) or views (2005).

[F4] brings up the property pages in other MS tools; I'm glad it does again in SMSS.

-Eddie

Eddie Wuerch
MCM: SQL