documentation
.HELP!
Installing SQL Server Documentation
SET DISABLE_DEF_CNST_CHK (Level 1)
Installing SQL Server
previous page
next page
Installing SQL Server
SET DISABLE_DEF_CNST_CHK (Level 1)
SQL Server 6.
x
SQL Server 2000
The SET DISABLE_DEF_CNST_CHK setting controlled interim constraint checking.
Removed; no longer available. Remove all references to SET DISABLE_DEF_CNST_CHK.
previous page
start
next page
Menu
Homepage
Table of contents
Overview of Installing SQL Server 2000
Preparing to Install SQL Server 2000
Hardware and Software Requirements for Installing SQL Server 2000
SQL Server 2000: Editions and Components
Installing English Query
Installing Analysis Services
Setting up Windows Services Accounts
File Paths for SQL Server 2000
Upgrading an Existing Installation of SQL Server
Basic Installation Options
Entering Information in Basic Setup Screens
Computer Name
Installation Selection
Existing Installation Options
Installation Definition
User Information
Instance Name
Setup Type: Typical, Minimum, or Custom
Select Components
Server Components
Management Tools
Client Connectivity
Books Online
Development Tools
Code Samples
Network Libraries
Services Accounts
Authentication Mode
Choose Licensing Mode
Installing a Remote Configuration
Remote Setup Information
Advanced Installation Options
Installing a Virtual Server Configuration
Failover Clustering: Defining the Virtual Server
Cluster Management Screen
Cluster Disk Selection Screen
Quorum Disk Selection Warning
Modify Node List Warning
Performing an Unattended Installation
Creating a Setup File Manually
Setup Initialization File Details
Installing SQL Server Using SMS
Rebuilding the Registry
Working with Named and Multiple Instances of SQL Server 2000
Naming Conventions for Instances of SQL Server 2000
Network Protocols for Named Instances
File Locations for Multiple Instances of SQL Server
Removing Multiple Instances of SQL Server 2000
Working with Instances and Versions of SQL Server
Using SQL Server 6.5 with SQL Server 2000
Running SQL Server 7.0 Along with a Named Instance of SQL Server 2000
Working with Three Versions of SQL Server
Collation Options for International Support
Collation Settings in Setup
Windows Collation Sorting Styles
Windows Collation Designators
Using SQL Collations
Examples of SQL Collations
Selecting a SQL Collation
Setting Client Code Pages
Upgrading Character Set, Sort Order, and Collation
Changing Collation Settings After Installing
Upgrading to SQL Server 2000: Overview
Hardware and Software Requirements for Upgrading
Upgrading from SQL Server 7.0 to SQL Server 2000
Replication and Upgrading
Upgrading Databases from SQL Server 7.0 (Copy Database Wizard)
Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)
Preparing to Upgrade from SQL Server 6.5
Estimating the Disk Space Required for Upgrading
Data and Object Transfer
Order of Upgrade Using a Direct Pipeline or Tape Drive
Upgrading Using One or Two Computers (Logon Screen)
Selecting a Scripting Code Page
Selecting Databases to Upgrade
Database Configuration
Proposed Database Layout
Tape Upgrade Transfer Options
System Configuration
Completing the SQL Server Upgrade Wizard
Upgrade Script Interpreter
Backward Compatibility
SQL Server 2000 and SQL Server version 7.0
SQL Server 2000 and SQL Server version 6.5
SQL Server Backward Compatibility Details
SetHostName property not used in SQL Server 2000
Level 1: Handling Discontinued Functionality
Level 2: Handling Major Changes to Behavior
Level 3: Updating to Improve Earlier Functionality
Level 4: Handling Minor Changes to Behavior
After Installing or Upgrading to SQL Server 2000
Using the Start Menu
System and Sample Databases
Locating Directories and Files
Changing Passwords and User Accounts
Renaming a Server
Deploying SQL Server After Initial Installation
Installing Full-Text Search and Indexing Tools
Configuring SQL Server 2000 After Upgrading
Switching Between SQL Server 6.5 and SQL Server 2000
Removing SQL Server 7.0 or SQL Server 6.5 After Upgrading
Removing SQL Server 2000
Get in touch
Submit feedback about this site to:
[email protected]