SQL SERVER – Management Studio and Browser in Same Application – SSMS Browser

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.

SQL SERVER - Management Studio and Browser in Same Application - SSMS Browser SSMS-Browser1

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.

Solarwinds

SQL SERVER - Management Studio and Browser in Same Application - SSMS Browser SSMS-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)

Solarwinds
, ,
Previous Post
SQL SERVER – FIX – ERROR – Service Logon Failure (ObjectExplorer)
Next Post
SQL SERVER – Running SSIS Package From Command Line

Related Posts

13 Comments. Leave new

  • Jacob Sebastian
    May 20, 2011 8:56 am

    This is a great tip. Thanks for sharing this.

    Reply
  • 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.

    Reply
  • Feodor Georgiev
    May 20, 2011 12:41 pm

    Good one. Thanks for the tip.

    Reply
  • Snehal Trivedi
    May 20, 2011 12:46 pm

    As fantsatic as You. It will make everybody’s learning more easier.

    Reply
  • Sandip Bagwe
    May 20, 2011 5:58 pm

    Good One…Thanks Pinal Sir…

    Reply
  • Good tip, thanks for sharing.

    Reply
  • Nakul Vachhrajani
    May 21, 2011 11:04 am

    Simply superb! Very, very useful. Thank-you for this great tip!

    Reply
  • 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!
    Thanks,
    MartinIsti

    Reply
  • Great post, I enjoy reading your articles here..Thanks

    Reply
  • 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?

    Reply
  • 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]
    “HomePage”=”http://google.com”

    Reply
  • Václav Kruml
    March 8, 2017 11:04 pm

    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…
    thanks

    Reply

Leave a Reply

Menu