Find/Replace Not Working in Management Console

I have the 2005 Standard Edition of Sql Server, and the managment console tonight stopped responding to quick find/replace requests either via menu or (ctrl+f, ctrl+h).

The UI bars above just grey out a bit and nothing happens. I saw a MSFT dev for VB (visual studio) respond with a fix that was to run "devenv.exe /resetsettings" that restored the defaults and fixed the problem for those affected.

Anyone know how to do that for management studio, since going to customize (restore) each of the individual bars didn't do it.

Thanks in advance,

Greg

Greg,

Please make sure that Find & Replace window is not docked (and possibly hidden) somewhere along the edges of Management Studio. It sometimes happens that a tool window gets docked and then slides to a hidden position so only it's caption bar is visible.

Regards,

|||

Maciek,

Thanks for the reply. I read this and said 'bah, no way'....

Well, there it was, the caption hiding like 1 pixel above the status bar...exposed if i made it temporarily auto-hide.

Thanks for this, again. One comment, though. I could select the window with ctrl+H...a nice way out of this would be an addition in the window menu bar to force it as floating center screen to get ahold of it again.

Greg

|||

Greg,

Glad I could help. We've seen this happening to number of people for some reason. I guess you are right - there should be an easy way to find that window. I'll open a suggestion for that.

Regards,

|||Did an easy way ever get implemented? I have the same problem and I can't find the tool window after moving everything around. I've noticed that the main menu changes when I attempt ctrl-F, the 'Query' between 'View' and 'Project' disappears.|||

I am not sure if a shortcut to center the windows was ever added. However, while the problem keeps happening to me I've become much more adept at finding that edge of the window hiding at a corner.

Drop the status bar, peer at the edges of the screen, and I find it every time...just drag it back to the middle.

Greg M

|||

I found it thanks to your hint though not quite in the way you describe. In fact I found a way of making the Find dialogue pop up centered. What I did was go to the "Task bar and Start Menu" properties window (right click on start menu). Then uncheck "autohide the task bar" and popup appeared in all its glory. Amazing. I had uninstalled and reinstalled and the problem persisted - cost hours! One thing it taught me though was how important find/replace functionality is to my development practice. I turn old code into new code using it.

|||

manay thanks

i had the same porblem

and i found the pop up under the task bar

many many thanks

Find/Replace Not Working in Management Console

I have the 2005 Standard Edition of Sql Server, and the managment console tonight stopped responding to quick find/replace requests either via menu or (ctrl+f, ctrl+h).

The UI bars above just grey out a bit and nothing happens. I saw a MSFT dev for VB (visual studio) respond with a fix that was to run "devenv.exe /resetsettings" that restored the defaults and fixed the problem for those affected.

Anyone know how to do that for management studio, since going to customize (restore) each of the individual bars didn't do it.

Thanks in advance,

Greg

Greg,

Please make sure that Find & Replace window is not docked (and possibly hidden) somewhere along the edges of Management Studio. It sometimes happens that a tool window gets docked and then slides to a hidden position so only it's caption bar is visible.

Regards,

|||

Maciek,

Thanks for the reply. I read this and said 'bah, no way'....

Well, there it was, the caption hiding like 1 pixel above the status bar...exposed if i made it temporarily auto-hide.

Thanks for this, again. One comment, though. I could select the window with ctrl+H...a nice way out of this would be an addition in the window menu bar to force it as floating center screen to get ahold of it again.

Greg

|||

Greg,

Glad I could help. We've seen this happening to number of people for some reason. I guess you are right - there should be an easy way to find that window. I'll open a suggestion for that.

Regards,

|||Did an easy way ever get implemented? I have the same problem and I can't find the tool window after moving everything around. I've noticed that the main menu changes when I attempt ctrl-F, the 'Query' between 'View' and 'Project' disappears.|||

I am not sure if a shortcut to center the windows was ever added. However, while the problem keeps happening to me I've become much more adept at finding that edge of the window hiding at a corner.

Drop the status bar, peer at the edges of the screen, and I find it every time...just drag it back to the middle.

Greg M

|||

I found it thanks to your hint though not quite in the way you describe. In fact I found a way of making the Find dialogue pop up centered. What I did was go to the "Task bar and Start Menu" properties window (right click on start menu). Then uncheck "autohide the task bar" and popup appeared in all its glory. Amazing. I had uninstalled and reinstalled and the problem persisted - cost hours! One thing it taught me though was how important find/replace functionality is to my development practice. I turn old code into new code using it.

|||

manay thanks

i had the same porblem

and i found the pop up under the task bar

many many thanks

Find All Children Of A specified Group ID

Hi all, Im designing a product menu like the one seenhere.
I need to be able to itterate through all product menu groups in a table and find all children of a specified parent. Sorry for the cryptic Explanation and crappyDiagram!

Please see mydiagramWhat does you table(s) look like? Can you post the DDL and some sample data?|||Certainly.

Here you go.|||Have you ever looped through all directories on a drive, folder by folder by coding a function that searches all subdirectories of a single directory and calls itself on each directory that it finds?

This is what im trying to achieve here, only by using stored procedures.|||>>Have you ever...

Sure. Here are some links which should get you on your way.

http://www.sqlteam.com/item.asp?ItemID=8866
http://www.intelligententerprise.com/001020/celko1_1.jhtml?_requestid=57013|||Nice one, Ta very much indeed!

'Find & Replace' functionality vanished in Management Studio

Hi,

Whenever I select a sub-menu option from the 'Find & Replace' menu item on the 'Edit' menu I get - nothing. Not the functionality, nor any error box. Was working perfectly earlier.

Any ideas?

Just a thought...

Find & Replace is a dockable tool window. Please scan the windows that you have docked around inside your main SSMS window, maybe it is hidden somewhere there, underneath another window or docked but not slide-out.

Regards,

|||Thanks. That was the exact problem. The dialog box was tucked behind the Taskbar.