Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
This article describes how to download and view offline SQL Server content in SQL Server Management Studio (SSMS). Offline content enables you to access the documentation without an internet connection (although an internet connection is initially required to download it).
Offline documentation is available for versions of SQL Server 2012 (11.x) and later versions. Although you can view content for previous versions online, an offline option provides a convenient way to access the older content.
If your system doesn't have internet access and you want to install the offline content, first download the content on a system that has internet access, and then move the package over to the offline system. Use SSMS to locate the installation file path and load the files.
The following steps explain how to load offline content for SQL Server, by using SQL Server Management Studio (SSMS) that has access to the internet.
This section describes how to load offline content for SQL Server 2014 (12.x).
Important
SQL Server 2014 (12.x) Transact-SQL content is only available offline.
Download the Product Documentation for Microsoft SQL Server 2014 for firewall and proxy restricted environments content from the download center and save it to a folder.
Unzip the file to view the *.msha*
file.
In SSMS, select Add and Remove Help Content on the Help menu.
The Help Viewer opens to the Manage Content tab.
To install the latest help content, choose Disk under Installation source and then the ellipses (...).
Note
The Local store path on the Manage Content tab shows where on the local computer the content is located. To change the location, select Move, enter a different folder path in the To field, and then select OK. If the help installation fails after changing the Local store path, close and reopen the Help Viewer. Ensure the new location appears in the Local store path and then try the installation again.
Locate the folder where you unzipped the content. Select the HelpContentSetup.msha
file in the folder then select Open.
Type in sql server 2014 in the search bar. Once you see the 2014 content available, select Add next to each content package (book) that you want to install to Help Viewer and then select Update.
Note
If the Help Viewer freezes (hangs) while adding content, change the Cache LastRefreshed="<mm/dd/yyyy> 00:00:00"
line in the %LOCALAPPDATA%\Microsoft\HelpViewer2.x\HlpViewer_SSMSx_en-US.settings
or HlpViewer_VisualStudiox_en-US.settings
file to some date in the future. For more information about this issue, see Visual Studio Help Viewer freezes.
You can verify that the SQL Server 2014 content installed by searching under the content pane on the left for sql server 2014.
You can view SQL Server help content using the Help menu in the latest version of SQL Server Management Studio (SSMS).
To view the installed help in SSMS, select Launch in Help Viewer from the Help menu, to launch the Help Viewer.
Help Viewer opens to the Manage Content tab, with the installed help table of contents in the left pane. Select Articles in the table of contents to display them in the contents pane.
Important
If the contents pane isn't visible, select Contents on the left margin. Select the pushpin icon to keep the contents pane open.
Review the Microsoft Product Lifecycle for information about how a specific product, service, or technology is supported:
Did you know that you can edit SQL content yourself? If you do so, not only do you help improve our documentation, but you also get credited as a contributor to the page.
For more information, see How to contribute to SQL Server documentation
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Learning path
Migrate SQL Server workloads to Azure SQL DP-3001 - Training
Learn how to perform online and offline SQL Server migrations to Azure SQL. (DP-3001)
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.