Sql-server – How to set MSDN in order to open on a certain version of Microsoft SQL Server

sql server

In a network, there are certain different installed versions of Microsoft SQL Server, starting with 2005, 2008 and 2008 R2.

Is there a specific option of MSDN that can fix the opening of new pages on the version of SQL Server that is being worked on?

For instance, can I set MSDN to open on Microsoft SQL Server 2008 R2, if I work only on that version?

EDIT in order to clarify what I am asking:

  1. When a user searches the Internet using a search engine for the syntax of a specific SQL statement, he might get to a MSDN web page such as the following one, which presents the "SELECT (Transact-SQL)" SQL statement:

https://msdn.microsoft.com/en-us/library/ms189499.aspx

  1. Even if the user is logged in the MSDN system using a user name such as "UserName123", there are no apparent settings – or maybe I have not found them yet – so that the version of the Microsoft SQL Server can be pre-set. Currently, always the pages open with the latest version, which is "SQL Server 2014".

  2. In this situation, the user has to select from the "Other Versions" drop-down list his preferred Microsoft SQL Server version, for instance "SQL Server 2005". There are cases when the user forgets to do that and reads the syntax for a version of Microsoft SQL Server that he is not interested in.

  3. Finally, the question: Is it possible to automatically pre-set somehow, using any MSDN user configuration settings, the Microsoft SQL Server version that is automatically chosen when displaying information?

Best Answer

I came up with a thrown-together hack with what I had on hand. If you don't have Fiddler installed, you'll need to get it from http://www.telerik.com/fiddler

Set it to Keep: 100 sessions then go to the AutoResponder tab and add this rule:

If request matches: regex:https://msdn.microsoft.com/en-us/library/ms(\d+)(\(v=sql.(100|105|110)\))?.aspx

Then respond with: *redir:https://msdn.microsoft.com/en-us/library/ms$1(v=sql.90).aspx

If you'd like to use a different version of SQL Server, then change the number at the end of the Respond With string and make sure to take that number out of the If Request Matches string or you'll end up in a redirect loop.

Enable rules and check Unmatched requests passthrough. Fiddler will have to capture traffic (F12) in order for this to function. The configuration screen should look like this:

Fiddler settings

Related Question