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 out who deleted rows?

Yesterday, I had an occurence where someone (one of our developers :) ) deleted many vital rows in a database. I was able to recover via a backup but I'd like to see what was run to delete those rows, when and who if possible? I have the transaction log and the _log.ldf.

Can I read those somehow to find out this information? I have since added auditing to said tables, but I'd really like to go back and see what happened?

I do know about Lumigent, but is there a different production/solution?

Thoughts?

Thank youDid you add triggers? Write all transaction to a history table...|||Brett.

See above, "I have since added auditing to said tables, but I'd really like to go back and see what happened?"....

Thanks for the thoughts though....

Anybody else on the read log file or transaction log files?

Find out whether a database is merge subscriber

Hi,
maybe someone can help me with this one.
I need to find out via T-SQL whether a specific database is a subscriber
of a merge publication. The publisher might not be available when
querying this.
I would have expected bit 4 (value 8) of
master.dbo.sysdatabases.category to be set; however, it isn't in my
replicated databases (maybe just for snapshot replication?)
Thanks for any help on this!
Roland
Roland,
you should be able to find the publication in sysmergesubscriptions on the
subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

find in Query Editor

This may have been mentioned before but why isn't there a "Close" button on
the Find dialog in the Query editor? Yes you can close it via the tiny X in
the corner but it should have a close or done button as well.
Andrew J. Kelly SQL MVP
Sorry posted in the wrong group
Andrew J. Kelly SQL MVP
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eVXuM43GFHA.2156@.TK2MSFTNGP09.phx.gbl...
> This may have been mentioned before but why isn't there a "Close" button
> on the Find dialog in the Query editor? Yes you can close it via the tiny
> X in the corner but it should have a close or done button as well.
>
> --
> Andrew J. Kelly SQL MVP
>
>