SQL SERVER – Management Studio and Browser in Same Application

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.

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.

Click to Enlarge

Now user can open 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.

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

11 thoughts on “SQL SERVER – Management Studio and Browser in Same Application

  1. 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.

  2. 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

  3. 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?

  4. 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”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s