Sunday, October 3, 2010

SQL Profiler is on my second screen, but my second screen is not connected.

I use a lot of time multiple screens on my laptop. With SQL Profiler this can give some challenges. I will explain in which situation.
  • Connect an extra monitor to your laptop.
  • Extend this screen as the second screen.
  • Start SQL Profiler and move it to the second screen.
  • Close SQL profiler on the second screen.
  • Disconnect the second screen.
  • Start SQL Profiler.
In the taskbar you can see that SQL profiler is active however you do not see SQL Profiler. It is still open on your not connected screen. This is a bug in SQL Profiler which does not reset the window position. What should you do to make use of the SQL Profiler if you do not have a second screen available.

  • Click on the SQL Profiler window in the taskbar.
  • Press ALT ENTER to get the propertie window of the SQL Profiler.
  • Select MOVE.
  • Use you arrow keys to move the invisible window back to your screen.
Enjoy the use of SQL Profiler.

7 comments:

Jayakumar said...

Andre, Thank you very much for this solution, it was frustrating for me when i am trying to open profiler from home where i don't have second monitor. You saved me. Thank you agian.

Have a wonderful new year 2014.

Jayakumar

irfan said...

Hi,

Thanks for this great tip, however it didn't work for me. I tried the tip I got from TechNet website which is..."Click the icon in the taskbar to ensure that the program has focus. Then hold down the Windows key and press the right-arrow a few times".

Hope this would help someone:)

Cheers,

ANIL said...

Thanks for the tip, Irfan. It worked for me and saved so much time. :)

Unknown said...

Wow this works!! thank you very much for sharing this solution!!

You saved my day!

Thanks.

mast bobinush said...

Alt + Enter or the Win+Right arrow does not work for me on Windows 10.
This is so frustrating! Wish they would fix this as I see it's been an issue for at least 13 years now..
Using SQL Profiler 18.12.1

Orson said...

@mast bobinush. I was having the same issue (Alt+Enter not working) and found this method: Shift + right-click on SQL profiler icon in taskbar then select "move". Use arrow keys to move the window back into view (from the direction in which your second screen used to be).

I hope this works for you,

Orson

mast bobinush said...

@Orson Yes that worked, thank you!