SSMS - feature

Question

SSMS - feature

Viewing 15 posts - 16 through 30 (of 79 total)

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

Mark Fitzgerald-331224 SSCrazy Eights Points: 8489 More actions · Answer 1

On a fresh install of SQL 2008 SSMS with the exact code given no message appears for me. Holding CTRL and click does as described, but the non-CTRL behaviour I found was nothing ie first answer. SSMS 2005 for me did show the pop-up text.

Fitz

Jorge Segarra SSCrazy Points: 2571 More actions · Answer 2

Very cool trick, didn't know about this. Thanks for sharing!

=============================================================
/* Backups are worthless, Restores are priceless */

Get your learn on at SQL University!
Follow me on Twitter | Connect on LinkedIn
My blog: http://sqlchicken.com
My book: Pro Server 2008 Policy-Based Management

Tom257 SSChampion Points: 11543 More actions · Answer 3

I have SQLEXPRESS 2008 + the free SSMS tool. There is no popup - but CTRL changes your cursor to a pointer (still no tooltip though, and nothing in the status bar)

I have no internet access on my SQL machine - so I tried it with

/* file:///C:/Temp/scratch.sql */

and got the IE File Download warning, (open/save/cancel) - the file opens fine, but also leaves a tab in SSMS "No Page to Display" showing an "Action Cancelled" IE page.

amarshall-568002 Right there with Babe Points: 785 More actions · Answer 4

I get nothing.

If I hold down the Ctrl key and hover my mouse over the link, then the pointer turns to a hand, and clicking on the link brings it up.

OCTom SSChampion Points: 11785 More actions · Answer 5

I get:

1. I have to press CTRL first. The finger shows up and I can click the URL.

2. I don't get any pop-up instructions.

I'm using SSMS 10.0.2531.0 (2008).

It's an interesting feature, though, and one that can make code more self-documenting.

Steve Eckhart SSCommitted Points: 1880 More actions · Answer 6

By the way, this feature is documented. From MSDN (http://msdn.microsoft.com/en-us/library/ms173887.aspx): SQL Server Management Studio hosts a version of Microsoft Internet Explorer. This Web browser allows you to browse URLs, and view MSDN Library help topics without leaving SQL Server Management Studio. You can access the Web browser by pointing to Web Browser on the View menu, and then clicking Show Browser.

Steve Eckhart

sing4you SSCrazy Points: 2984 More actions · Answer 7

Wow, what a cool feature. I had no idea. Thanks!

And it works in SQL 2005 😛

rustman SSCarpal Tunnel Points: 4157 More actions · Answer 8

I also get nothing unless I hold down the Ctrl key while hovering over the link with the mouse.

It then works as stated but no popups happen. It is always interesting where we assume "default" behaviors would work but rarely do they work on everyone's machines the same...

Cliff Jones SSChampion Points: 10547 More actions · Answer 9

Very interesting. I had no idea you could do that. Thanks.

pjdiller SSC Eights! Points: 977 More actions · Answer 10

pjdiller

SSC Eights!

Points: 977

March 24, 2010 at 7:51 am

#1138930

Yeah, just hovering. Not so much. Ctrl required.

Dave62 SSCertifiable Points: 7459 More actions · Answer 11

I had the same experience I see a lot of others posting.

With a SQL Server 2008 installation on a machine with Internet Explorer as the default browser and access to the internet, nothing happens when I hold my mouse over the url.

If I press the ctrl key and move the mouse on the url the cursor changes to a hand but no popup. Then I can click the link and it opens in a new SSMS tab.

Nice feature in SSMS I never knew about.

Dave

sknox SSChampion Points: 12388 More actions · Answer 12

I just tested this, and got the following results:

SSMS 2005 - popup came up "CTRL-Click to open...", CTRL-click opens in a new tab.

SSMS 2008 - NO POPUP, CTRL-click opens in a new tab.

So I'm guessing they removed the tooltip popup in SSMS 2008, but not the underlying functionality?

Dave62 SSCertifiable Points: 7459 More actions · Answer 13

sknox (3/24/2010)
...
SSMS 2005 - popup came up "CTRL-Click to open...", CTRL-click opens in a new tab.
SSMS 2008 - NO POPUP, CTRL-click opens in a new tab.
So I'm guessing they removed the tooltip popup in SSMS 2008, but not the underlying functionality?

Right. Looks like an additional piece of criteria was needed. "in SSMS 2005."

Dave

WayneS SSC Guru Points: 95460 More actions · Answer 14

Very nice. I didn't know about this.

It seems that you can only have one web tab open though... it would be REALLY nice if you could open up multiple tabs.

Then when the boss says something about being on the web, I can show how I'm actually working in SSMS:-P

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Shawn Melton SSC-Insane Points: 24685 More actions · Answer 15

Yeah...no luck here either without CTRL held down.

I found they that the option under Text Editor > Any Option > General, includes an "Enable single-click URL navigation". This was clicked apparently by default under my instance of SSMS but it does not work.:-P

Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton