Adding and Removing Help Collections

Because Microsoft SQL Server can be used with different applications, SQL Server Books Online includes information about these applications. For example, in SQL Server you can:

  • Create common language runtime (CLR) stored procedures and triggers against SQL Server databases.

  • Write client tools for SQL Server Reporting Services by using ASP.NET.

In these scenarios, it is useful to have access to documentation for development applications. Accordingly, SQL Server Books Online topics link to topics in these applications' Help collections where appropriate. In particular, many programming reference topics link to topics that are included in documentation for the .NET Framework.

Help Collections and SQL Server

A Help collection is a set of Help topics. SQL Server Books Online is the primary Help collection included with SQL Server. A second documentation-related item is the Windows SDK for Windows Server 2008 and .NET Framework 3.5, available as a free download.

By default, links are not functional between topics in the SQL Server Books Online Help collection and topics in the documentation from the .NET Framework, or any other installed documentation. However, it is possible to enable these links by adding the appropriate Help collections to SQL Server Books Online.

注意

If SQL Server Books Online and the Visual Studio 2008 MSDN Library are installed on the same computer, links between SQL Server Books Online and the MSDN Library will automatically work when Help is opened from Business Intelligence Development Studio.

Install additional Help collections with SQL Server Books Online to consolidate your software library and enable links from SQL Server Books Online to the .NET Framework documentation. The steps to install the MSDN Library and the .NET Framework documentation depend on what SQL Server components you use to access Books Online. For more information see, Installing the .NET Framework Documentation

Adding the .NET Framework SDK to SQL Server Books Online

The way you add Help content to SQL Server Books Online collection depends on how you access SQL Server Books Online.

If you have SQL Server Books Online installed as a separate component or use SQL Server Management Studio, complete the following steps to enable the links from SQL Server Books Online to the .NET Framework SDK documentation:

  1. Install the .NET Framework documentation.

  2. Open the Combined Help Collection Manager and add the Help collection to SQL Server Books Online. For more information, see SQL Server Combined Help Collection Manager.

Removing Help Collections

A similar approach can be used to remove Help collections . To remove a Help collection from SQL Server Books Online, see SQL Server Combined Help Collection Manager.

To completely uninstall SQL Server Books Online, open Add or Remove Programs in Control Panel, select Microsoft SQL Server, and click Change. The Microsoft SQL Server Maintenance dialog box appears. Select Workstation Components in SQL Server common components, and then click Next. In the Setup wizard, click Change Installed Components, and then clear SQL Server Books Online.

If you install Business Intelligence Development Studio, SQL Server Books Online, and the MSDN Library, two copies of SQL Server Books Online might appear in the table of contents: one of these was installed by the MSDN Library, and the other by SQL Server. To avoid duplicate search and index results, remove the MSDN Library copy of SQL Server Books Online. In Control Panel, open Add or Remove Programs, select MSDN Library for Visual Studio 2008, and click Change.

To remove SQL Server 2000 and SQL Server 2008 Books Online topics from search and index results, remove SQL Server 2000 Books Online from the MSDN Library. In Control Panel, open Add or Remove Programs, select MSDN Library for Visual Studio 2008, and click Change.