Chapter 39 - Tools, Samples, eBooks, and More

This chapter describes the contents of the CD that accompanies the Microsoft SQL Server 2000 Resource Kit, which includes an electronic version of the printed book, several files of information in eBook format, an electronic version of the popular Microsoft SQL Server 2000 System Tables Map, and a number of tools and samples.

Electronic Version of the Resource Kit Book

Cc917667.spacer(en-us,TechNet.10).gif Cc917667.spacer(en-us,TechNet.10).gif

An electronic version of the Microsoft SQL Server 2000 Resource Kit printed 1050405444book is available on the CD in the file Sqlrk.chm, located in the \Docs folder. You can view this file by double-clicking the file name.


Cc917667.spacer(en-us,TechNet.10).gif Cc917667.spacer(en-us,TechNet.10).gif

Six files available on the CD have been prepared in eBook format for viewing on a personal or laptop computer, or a Pocket PC device using Microsoft® Reader with ClearType™ technology. Microsoft Reader for personal computers and laptops can be downloaded from Microsoft Reader is available on Pocket PC devices manufactured by Hewlett-Packard, Casio, and Compaq. The eBook files are located in the \Docs\eBooks folder on the CD, and contain information from this resource kit and from SQL Server Books Online.

These are the eBook files and their contents:




The "What's New in SQL Server 2000" section of SQL Server Books Online


The "SQL Server Architecture" section of SQL Server Books Online


The "SQL Server Replication" section of SQL Server Books Online


The "Managing SQL Server Security" section of SQL Server Books Online


The "Data Warehouse Design Considerations" chapter in this Resource Kit


The "Using Views with a View on Performance" chapter in this Resource Kit

For more information about installing and using these files, see Readme.txt on the CD.

Content in the eBook files differs from how it appears in SQL Server Books Online and the Microsoft SQL Server 2000 Resource Kit due to limitations in the Reader format for the handheld devices. The limitations are:

  • Link functionality is not available in eBook format. Therefore, in the eBook files that contain sections from SQL Server Books Online, all See Also links have been removed. In addition, remaining links in these files may not be available, as some links reference sections of SQL Server Books Online that are not included on this CD. To view these links, see SQL Server Books Online.

    Note You can access URLs in both SQL Server Books Online and the online version of the Microsoft SQL Server 2000 Resource Kit

  • All tables have been converted to lists.

  • All of the illustrations have been removed. To view illustrations, see SQL Server Books Online or the print or electronic version of the Microsoft SQL Server 2000 Resource Kit

System Table Map

Cc917667.spacer(en-us,TechNet.10).gif Cc917667.spacer(en-us,TechNet.10).gif

The printed SQL Server 2000 System Table Map has been a very popular tool for database administrators, programmers, and other professionals working with SQL Server 2000. The Online System Table Map incorporates the benefits of the visual representation of table relationships from the printed version of the map with the same level of technical detail found in the system table topics in the Transact-SQL Reference.

The Online System Table Map supplies a visual representation of the relationships between tables, similar to that found in the printed version of the map. Selecting a specific table in the online map displays a topic with all of the information from the Transact-SQL Reference topic documenting the table. The See Also section in each topic has links to all tables related to the table you are currently viewing, allowing you to easily move between related tables. The Online System Table Map file, Systbl.chm, is located in the \Docs folder on the CD. You can view this file by double-clicking the file name.

The SQL Server 2000 System Table Map is 27 inches by 34 inches and printed in color. You can download the SQL Server 2000 SystemTable Map at

Tools and Samples

Cc917667.spacer(en-us,TechNet.10).gif Cc917667.spacer(en-us,TechNet.10).gif

The tools and samples listed below are available on the CD to help you more effectively use, manage, and develop applications for Microsoft SQL Server™ 2000.

Detailed information about these items can be found in the file Sqlrktls.chm in the \ToolsAndSamples folder on the CD. (An additional copy of this file also located in the \Docs folder on the CD.)

Tools and samples are located on the CD in the ToolsAndSamples folder. A short name is provided in parentheses for each tool or sample listed below; this short name is the name of the folder on the CD that contains the item.

Note If a chapter in the book contains extensive code example listings, the code for that chapter is also contained in a text file, located on the CD, in the Docs\ChapterCode folder in a file named CHnnCode.txt, where nn is the number of the chapter. You can copy and paste chapter code examples from the text file without having to enter them from the keyboard.

The following tools and samples can be found on the CD:

Tool Name


Microsoft Access 2000 Upgrade for SQL Server 2000 (AccessUpsizing)

Provides two fixes for Access 2000 so that Access 2000 can upsize an Access database (.mdb) to SQL Server 2000, and use an Access project (.adp) to create new databases against SQL Server 2000.

Administration Stored Procedures (AdminStoredProcedures)

User-defined stored procedures that identify SQL Server 2000 configurations with parameter settings outside of the recommended configuration.

Analysis Services Thin Web Client Browser (AnalysisServicesThinWebClient)

Browses an Analysis Services cube with Microsoft Internet Explorer using Active Server Pages (ASP).

Bulk Image Insert (BII)

Copies data between an instance of SQL Server 2000 and a data file. This utility behaves much like the bcp utility packaged with SQL Server 2000, except that when the input is the name of a locatable file and the destination is an image field, then the bii utility inserts the contents of the file into the image field.

Binary Large Objects (BLOB)

1050405445Demonstrates 1050405445ways to read, retrieve, and save binary large objects (BLOBs) in the Northwind sample database using Microsoft ActiveX® Data Objects (ADO) (Microsoft Visual Basic®), OLE DB (Microsoft Visual C++®), and ODBC (Visual C++).

Catalog Explorer (CatalogExplorer)

Retrieves meta data relating to OLAP objects, such as cubes and dimensions, from an Analysis server using ADO and Microsoft ActiveX Data Objects (Multidimensional) (ADO MD).

Database Hammer (DatabaseHammer)

A customizable tool for testing your database server with various loads.

Data Mining Visual ToolKit (DataMiningVisualToolKit)

Displays data mining operations of the Microsoft ActiveX Data Objects Library (ADODB). Includes three ActiveX controls: the Decision Tree Viewer, the Segment Viewer (for Cluster Analysis), and the Life Chart.

Database Generator (DBGen)

Populates tables in databases with dummy information. You can specify the distribution of the data for each column.

Database Management (DBManagement)

Tools and samples for administering SQL Server databases, including Web pages to display system information, trace procedures, development procedures, administration procedures, and a customizable MMC console for managing SQL Server.

Digital Dashboard (DigitalDashboard)

A sample interactive digital dashboard that displays data in a SQL Server database.

Federated Toolkit Samples (FederatedToolkitSamples)

Demonstrates distributed partitioned views using a sample ordering application that emulates an online store with multiple worldwide ordering locations.

MetaData Dashboard (MetaDataDashboard)

A digital dashboard that displays Analysis Services meta data.

Meta Data Scripter (MetaDataScripter)

Scripts the meta data of Analysis Services objects, generating a Microsoft Visual Basic Scripting Edition (VBScript) file that uses Decision Support Objects (DSO) to re-create the objects.

Multiphase Data Pump (MonitorDTS)

Monitors a Data Transformation Services (DTS) Multiphase Data Pump in Visual Basic.

Desktop SQL Server Configuration Tool (MSDEAdministrationTool)

An administration and configuration tool that demonstrates how Access 2000 can be used to programmatically connect to and manage a SQL Server.

Northwind Cube (NorthwindCube)

Demonstrates the efficiency of a query that utilizes a star schema rather than a normalized OLTP schema.

OLE Database Data Mining Query (OLEDBDMQuery)

Demonstrates how to execute OLE DB for Data Mining queries against an Analysis Services server.

Parallel Process (ParallelProcess)

Processes Analysis Services cubes and partitions in parallel.

Partition Manager (PartitionManager)

Manages Analysis Services cube partitions.

Sample Resolver (SampleResolver)

Shows how an application can be used against specific events called by SQL Server and how to use methods in a DLL provided by the SQL Server Library.

Schema Rowset Explorer (SchemaRowsetExplorer)

Retrieves Analysis Services schema rowsets and meta data and displays the column layout and data for ADO Recordset objects.

Set Certificate (SetCert)

Allows you to specify which Microsoft Windows security certificate SQL Server 2000 will use to perform encryption.

Simple Log Shipper (SimpleLogShipper)

A simplified log-shipping tool that provides basic log-shipping functionality.


Demonstrates how to manipulate SQL Distributed Management Objects (SQL-DMO) objects.

Stored Procedure Builder (StoredProcBuilder)

Manages and controls the building of SQL Server stored procedures maintained in Microsoft Visual SourceSafe™.

Transact-SQL Quick Reference (TSQLQuickReference)

An online quick reference of syntax differences between Transact-SQL in SQL Server 7.0 and SQL Server 2000, and of core-level syntax differences between SQL standard (SQL:1999) and SQL Server 2000.

UDF MixCase (UDF_MixCase)

An SQL function that converts all uppercase or lowercase strings to title case (first letter capitalized).

USP Shutdown Database (USP_ShutdownDB)

A procedure that terminates all open user connections to a specified SQL Server database, and optionally executes a command after it terminates the connections.