First of all – I must confess that I was not aware of this feature till I noticed it today. At home, I have multiple monitors, but when I am traveling, I have single laptop along with me. It is often that when I am working with SQL Server I have to refer web for information on the subject I am working on. Let us understand about SSMS Browser in this blog post.
Recently I pressed CTRL+ALT+R and suddenly a web browser opened in SSMS. I later realize that I can also access the same from SSMS >> View >> Other Windows >> Web Browser.
Now user can open a web browser and New Query editor and split them vertically (Go to Windows and click on New Vertical Tab Groups) and have both side by side. Very near feature. I am personally going to use it again and again.
Here are my follow up questions for you-
- How many monitors do you have when you go to work?
- Do you use multiple monitors at home?
- Have you ever used SQL Server Management Studio Browser? If yes, would you please tell me real world scenario.
Leave a comment to answer questions.
Reference: Pinal Dave (https://blog.sqlauthority.com)
This is a great tip. Thanks for sharing this.
HA! Just when you think you know all the tricks a DBA can use in SSMS, you go ahead and stumble across something like this. I’m always surprised by just how many cool time saving features there are in the product that we often don’t know about.
Thanks for sharing.
Good one. Thanks for the tip.
As fantsatic as You. It will make everybody’s learning more easier.
Good One…Thanks Pinal Sir…
Good tip, thanks for sharing.
Simply superb! Very, very useful. Thank-you for this great tip!
Thanks for this, I also discovered it accidentally in the past and it’s quite a good feature I agree!
I would like to ask your help/opinion with another issue in SSMS (not directly related to this browser stuff but I haven’t found it on the net, probably because I don’t know the correct search words or maybe there’s no solution for it): when I right-click on a table in object explorer and “Select Top 1000 Rows” the query includes the database name in the FORM clause and the active database is master (as shown in the bar above). It’s getting annoying for me because I don’t like including the db name in a query (it needs additional typing :)) and when you work with SSIS you’d better leave out that anyway.
Do you think there’s a setting for SSMS to exclude the db name from the query and change to that database instead?
I would be grateful if you could help me!
Great post, I enjoy reading your articles here..Thanks
I found this last night but have been unable to find a way of setting the homepage to something i want it to be, any ideas?
The home page is hidden in the registry…
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100\Tools\Shell\WebBrowser]
hello, i know this future for long time, but for me is absolutely useless (because of IE). this gives a little discomfort, because if i click on some link in SSMS (for example in SQL script comment), the internal SSMS browser is opened. is there any possibilities to disable this internal browser and use standard, default system browser ? i can’t found this option in SSMS settings…
I don’t think so…