Table of contents
-
How to Install SQL Server 2000
- How to install SQL Server 2000 (Setup)
- How to install client tools only (Setup)
- How to install tools only from any compact disc (Setup)
- How to install connectivity only (Setup)
- How to install a named instance of SQL Server 2000 (Setup)
- How to upgrade a SQL Server 7.0 installation to SQL Server 2000 (Setup)
- How to upgrade databases online using the Copy Database Wizard (Enterprise Manager)
- How to perform an edition upgrade within SQL Server 2000 (Setup)
- How to uninstall an existing installation of SQL Server (Setup)
- How to test an installation of SQL Server 2000 (Command Prompt)
- How to change SQL Server services login account information (Windows NT)
- How to change SQL Server services login account information (Windows)
- How to change SQL Server services login account information (Enterprise Manager)
- How to rebuild the registry (Setup)
- How to rebuild the master database (Rebuild Master utility)
- How to perform a remote installation of SQL Server 2000 (Setup)
- How to record an unattended installation file (Setup)
- How to run an unattended installation of SQL Server 2000 (Command Prompt)
- How to add components to an instance of SQL Server 2000 (Setup)
- How to access SQL Server Books Online for SQL Server 7.0
- How to install English Query (Setup)
- How to install Analysis Services (Setup)
- How to create a case-sensitive instance of SQL Server 2000 (Setup)
- How to set client code pages
- How to switch from SQL Server 6.5 to SQL Server 2000 (Command Prompt)
- How to switch from SQL Server 6.5 to SQL Server 2000 (Windows)
- How to remove SQL Server 2000 (Windows)
-
How To Upgrade from SQL Server 6.5
- How to change the size of tempdb in SQL Server 6.5 (ISQL/w)
- How to change to the current server name in the SQL Server 6.5 master database (ISQL/w)
- How to update the device file locations in the SQL Server 6.5 master database (ISQL/w)
- How to estimate the disk space required for an upgrade from SQL Server version 6.5 to SQL Server 2000 (SQL Server Upgrade Wizard)
- How to edit the default database configuration (SQL Server Upgrade Wizard)
- How to perform a SQL Server version 6.5 to SQL Server 2000 upgrade using a direct pipeline (SQL Server Upgrade Wizard)
- How to perform a SQL Server version 6.5 to SQL Server 2000 upgrade using a tape drive (SQL Server Upgrade Wizard)
-
SQL Server Enterprise Manager
-
Administering SQL Server
- How to start an instance of SQL Server automatically (Enterprise Manager)
- How to shut off automatic startup of SQL Server (Enterprise Manager)
- How to start SQL Server (Enterprise Manager)
- How to stop SQL Server or SQL Server Agent (Enterprise Manager)
- How to start the default instance of SQL Server (Service Manager)
- How to start a clustered instance of SQL Server (Service Manager)
- How to start a named instance of SQL Server (Service Manager)
- How to start the default instance of SQL Server (Windows)
- How to start a named instance of SQL Server (Windows)
- How to start the default instance of SQL Server (Command Prompt)
- How to start a named instance of SQL Server (Command Prompt)
- How to start the default instance of SQL Server in single-user mode (Command Prompt)
- How to start a named instance of SQL Server in single-user mode (Command Prompt)
- How to start the default instance of SQL Server with minimal configuration (Command Prompt)
- How to start a named instance of SQL Server with minimal configuration (Command Prompt)
- How to pause and resume the default instance of SQL Server (Service Manager)
- How to stop a clustered instance of SQL Server (Service Manager)
- How to pause and resume a named instance of SQL Server (Service Manager)
- How to pause and resume the default instance of SQL Server (Windows)
- How to pause and resume a named instance of SQL Server (Windows)
- How to pause and resume the default instance of SQL Server (Command Prompt)
- How to pause and resume a named instance of SQL Server (Command Prompt)
- How to broadcast a shutdown message (Command Prompt)
- How to stop the default instance of SQL Server (Windows)
- How to stop a named instance of SQL Server (Windows)
- How to stop the default instance of SQL Server (Command Prompt)
- How to stop a named instance of SQL Server (Command Prompt)
- How to log in to the default instance of SQL Server (Command Prompt)
- How to log in to a named instance of SQL Server (Command Prompt)
- How to change the default service (Service Manager)
- How to create a new failover cluster (Setup)
- How to install a one-node failover cluster (Setup)
- How to add nodes to an existing virtual server (Setup)
- How to remove a node from an existing failover cluster (Setup)
- How to remove a failover clustered instance (Setup)
- How to recover from failover cluster failure in Scenario 1
- How to recover from failover cluster failure in Scenario 2
- How to upgrade from a SQL Server 6.5 active/passive failover cluster (Setup)
- How to upgrade from a SQL Server 6.5 active/active failover cluster (Setup)
- How to upgrade from a SQL Server 7.0 active/active failover cluster (Setup)
- How to upgrade from a SQL Server 7.0 active/passive failover cluster (Setup)
- How to upgrade from a default instance to a default clustered instance of SQL Server 2000 (Setup)
- How to upgrade from a local default instance to a clustered, named instance of SQL Server 2000 (Setup)
-
Backing Up and Restoring Databases
- How to create a logical disk backup device (Enterprise Manager)
- How to create a logical tape backup device (Enterprise Manager)
- How to delete a logical backup device (Enterprise Manager)
- How to create a database backup (Enterprise Manager)
- How to start the Create Database Backup Wizard (Enterprise Manager)
- How to restore a database backup (Enterprise Manager)
- How to restore a backup from a backup device (Enterprise Manager)
- How to create a transaction log backup (Enterprise Manager)
- How to apply a transaction log backup (Enterprise Manager)
- How to create a differential database backup (Enterprise Manager)
- How to restore a differential database backup (Enterprise Manager)
- How to set up, maintain, and bring online a standby server (Enterprise Manager)
- How to restore to a point in time (Enterprise Manager)
- How to view the data and log files in a backup set (Enterprise Manager)
- How to view backup and media header information (Enterprise Manager)
- How to back up files and filegroups (Enterprise Manager)
- How to restore files and filegroups (Enterprise Manager)
- How to restore files and filegroups over existing files (Enterprise Manager)
- How to set the recovery model for a database (Enterprise Manager)
-
Managing Servers
- How to register a server (Enterprise Manager)
- How to create server groups (Enterprise Manager)
- How to change a server's registration (Enterprise Manager)
- How to remove a registered server running SQL Server (Enterprise Manager)
- How to connect to a registered server running SQL Server (Enterprise Manager)
- How to disconnect from a registered server running SQL Server (Enterprise Manager)
- How to assign the sa password on a newly installed server (Enterprise Manager)
- How to view server properties (Enterprise Manager)
- How to check and set remote server configuration options (Enterprise Manager)
- How to set up a central store for server registration information (Enterprise Manager)
- How to set access to your display of servers and groups (Enterprise Manager)
- How to set the polling interval (Enterprise Manager)
- How to disable a remote server setup (Enterprise Manager)
- How to manage or view SQL Server messages (Enterprise Manager)
- How to edit a SQL Server message (Enterprise Manager)
- How to delete a SQL Server message (Enterprise Manager)
- How to add a new SQL Server message (Enterprise Manager)
- How to find a SQL Server message (Enterprise Manager)
- How to set up a linked server (Enterprise Manager)
- How to delete a linked server (Enterprise Manager)
- How to configure log shipping (Enterprise Manager)
- How to remove log shipping (Enterprise Manager)
- How to add or edit a destination server (Enterprise Manager)
- How to delete a destination server (Enterprise Manager)
- How to view the status of servers configured for log shipping (Enterprise Manager)
- How to view or edit information about the source server (Enterprise Manager)
- How to view or edit information about the destination server (Enterprise Manager)
- How to add an external tool to the Tools menu (Enterprise Manager)
- How to launch SQL Server Enterprise Manager in the Computer Management console (Windows)
- How to enable child windows (Enterprise Manager)
- How to configure the affinity mask (Enterprise Manager)
- How to set the allow updates option (Enterprise Manager)
- How to configure the cost threshold for parallelism (Enterprise Manager)
- How to set the default language (Enterprise Manager)
- How to set a fixed fill factor (Enterprise Manager)
- How to configure the number of processors available for parallel queries (Enterprise Manager)
- How to set minimum query memory (Enterprise Manager)
- How to configure the maximum number of worker threads (Enterprise Manager)
- How to set the backup retention duration (Enterprise Manager)
- How to set a fixed amount of memory (Enterprise Manager)
- How to set the nested triggers option (Enterprise Manager)
- How to set the priority boost option (Enterprise Manager)
- How to set the recovery interval (Enterprise Manager)
- How to set remote server access (Enterprise Manager)
- How to enforce distributed transactions for remote procedures (Enterprise Manager)
- How to set a time limit for remote queries (Enterprise Manager)
- How to set the working set size option (Enterprise Manager)
- How to set the two digit year cutoff option (Enterprise Manager)
- How to set user connections (Enterprise Manager)
- How to configure user options (Enterprise Manager)
- How to configure packet size (Enterprise Manager)
- How to set the query governor cost limit option (Enterprise Manager)
- How to enable encryption after SQL Server has been installed (Network Utility)
- How to connect to SQL Server through Microsoft Proxy Server (Setup)
- How to set the polling interval (Service Manager)
- How to configure a mail profile (Windows)
- How to set up SQL Mail (Enterprise Manager)
- How to set up SQLAgentMail (Enterprise Manager)
- How to enable the Lock Page in Memory option (Windows)
- How to start the SQL Server Network Utility (Network Utility)
- How to load an installed server network library (Network Utility)
- How to deactivate a server network library configuration (Network Utility)
- How to edit a server network library configuration (Network Utility)
- How to view the installed SQL Server server network libraries (Network Utility)
-
Managing Clients
- How to start the Client Network Utility (Windows)
- How to display the network library version numbers (Client Network Utility)
- How to set DB-Library conversion preferences (Client Network Utility)
- How to add a network library configuration (Client Network Utility)
- How to edit a network library configuration (Client Network Utility)
- How to delete a network library configuration (Client Network Utility)
- How to alias a client to an alternate pipe (Client Network Utility)
- How to configure a client to use the Multiprotocol Net-Library (Client Network Utility)
- How to configure a client to use TCP/IP (Client Network Utility)
- How to configure a client to use the NWLink IPX/SPX network library (Client Network Utility)
- How to configure a client to use the AppleTalk network library (Client Network Utility)
- How to configure a client to use the Banyan VINES network library (Client Network Utility)
- How to configure a client to use the VIA network library (Client Network Utility)
- How to configure a client to use a nonstandard network library (Client Network Utility)
- How to verify that SQL Server is listening on AppleTalk and can accept a client connection (Client Network Utility)
- How to check the ODBC SQL Server driver version (Windows)
-
Automating Administrative Tasks
- How to set the service startup account for SQL Server Agent (Enterprise Manager)
- How to set the mail profile for SQL Server Agent (Enterprise Manager)
- How to set the SQL Server connection (Enterprise Manager)
- How to set a SQL Server alias (Enterprise Manager)
- How to create a job (Enterprise Manager)
- How to disable a job (Enterprise Manager)
- How to create a job category (Enterprise Manager)
- How to delete a job category (Enterprise Manager)
- How to assign a job to a job category (Enterprise Manager)
- How to change the membership of a job category (Enterprise Manager)
- How to give others ownership of a job (Enterprise Manager)
- How to create a CmdExec job step (Enterprise Manager)
- How to reset SQLAgentCmdExec permissions (Enterprise Manager)
- How to define Transact-SQL job step options (Enterprise Manager)
- How to create an Active Script job step (Enterprise Manager)
- How to set job step success or failure flow (Enterprise Manager)
- How to set up the job history log (Enterprise Manager)
- How to view the job history (Enterprise Manager)
- How to make a master server (Enterprise Manager)
- How to make a target server (Enterprise Manager)
- How to enlist a target server from a master server (Enterprise Manager)
- How to defect a target server from a master server (Enterprise Manager)
- How to defect multiple target servers from a master server (Enterprise Manager)
- How to view a master SQL Server Agent error log (Enterprise Manager)
- How to check the status of a target server (Enterprise Manager)
- How to schedule a job (Enterprise Manager)
- How to set CPU idle time and duration (Enterprise Manager)
- How to notify an operator of job status (Enterprise Manager)
- How to write the job status to the Windows application log (Enterprise Manager)
- How to automatically delete a job (Enterprise Manager)
- How to set the polling interval for target servers (Enterprise Manager)
- How to start a job (Enterprise Manager)
- How to stop a job (Enterprise Manager)
- How to force a target server to poll the master server (Enterprise Manager)
- How to view a job (Enterprise Manager)
- How to resize the job history log (Enterprise Manager)
- How to clear the job history log (Enterprise Manager)
- How to modify a job (Enterprise Manager)
- How to modify the target servers for a job (Enterprise Manager)
- How to modify a target server's location (Enterprise Manager)
- How to delete a job (Enterprise Manager)
- How to synchronize target server clocks (Enterprise Manager)
- How to script jobs using Transact-SQL (Enterprise Manager)
- How to create an operator (Enterprise Manager)
- How to assign alerts to an operator (Enterprise Manager)
- How to format pager addresses (Enterprise Manager)
- How to designate a fail-safe operator (Enterprise Manager)
- How to create an alert using an error number (Enterprise Manager)
- How to create an alert using severity level (Enterprise Manager)
- How to define the response to an alert (Enterprise Manager)
- How to create a user-defined event error message (Enterprise Manager)
- How to edit a user-defined event error message (Enterprise Manager)
- How to delete a user-defined event error message (Enterprise Manager)
- How to disable or reactivate an alert (Enterprise Manager)
- How to designate an events forwarding server (Enterprise Manager)
- How to view information about an operator (Enterprise Manager)
- How to edit an operator (Enterprise Manager)
- How to change an operator's availability (Enterprise Manager)
- How to delete an operator (Enterprise Manager)
- How to view information about an alert (Enterprise Manager)
- How to edit an alert (Enterprise Manager)
- How to delete an alert (Enterprise Manager)
- How to script operators using Transact-SQL (Enterprise Manager)
- How to script alerts using Transact-SQL (Enterprise Manager)
- How to set job execution shutdown (Enterprise Manager)
- How to autostart SQL Server Agent (Enterprise Manager)
- How to send SQL Server Agent error messages (Enterprise Manager)
- How to view SQL Server Agent error log (Enterprise Manager)
- How to rename a SQL Server Agent error log (Enterprise Manager)
- How to write execution trace messages to the SQL Server Agent error log (Enterprise Manager)
- How to schedule a DTS package using the SQLServerAgent service (Enterprise Manager)
- How to create a SQL Server 7.0 compatible script (Enterprise Manager)
-
Managing Security
- How to set up Windows Authentication Mode security (Enterprise Manager)
- How to set up Mixed Mode security (Enterprise Manager)
- How to grant a Windows user or group login access to SQL Server (Enterprise Manager)
- How to grant a Windows user or group access to a database (Enterprise Manager)
- How to add a SQL Server login (Enterprise Manager)
- How to add a linked server login (Enterprise Manager)
- How to grant a SQL Server login access to a database (Enterprise Manager)
- How to create a SQL Server database role (Enterprise Manager)
- How to add a member to a SQL Server database role (Enterprise Manager)
- How to add a member to a fixed server role (Enterprise Manager)
- How to grant SQL Server login access to a user by using the Create Login Wizard (Enterprise Manager)
- How to view a SQL Server login or Windows user or group (Enterprise Manager)
- How to view a database user (Enterprise Manager)
- How to change the password of a SQL Server login (Enterprise Manager)
- How to change the default database of a login (Enterprise Manager)
- How to change the default language of a login (Enterprise Manager)
- How to remove a user or group from a database (Enterprise Manager)
- How to remove a SQL Server login (Enterprise Manager)
- How to revoke a Windows user or group login access from SQL Server (Enterprise Manager)
- How to deny login access to a Windows user or group (Enterprise Manager)
- How to remove a linked server login (Enterprise Manager)
- How to view the roles defined in the current database (Enterprise Manager)
- How to view the fixed server roles (Enterprise Manager)
- How to view the members of a database role (Enterprise Manager)
- How to remove a user account from a database role (Enterprise Manager)
- How to view the members of a fixed server role (Enterprise Manager)
- How to remove a login from a fixed server role (Enterprise Manager)
- How to remove a SQL Server role (Enterprise Manager)
- How to allow access by granting permissions (Enterprise Manager)
- How to grant statement permissions to users within a database (Enterprise Manager)
- How to grant permissions on multiple objects to a user, group, or role (Enterprise Manager)
- How to prevent access by denying permissions (Enterprise Manager)
- How to deny statement permissions from users within a database (Enterprise Manager)
- How to deny permissions on multiple objects to a user, group, or role (Enterprise Manager)
- How to revoke permissions on an object (Enterprise Manager)
- How to revoke statement permissions from users in a database (Enterprise Manager)
- How to revoke permissions on multiple objects from a user, group, or role (Enterprise Manager)
- How to create an application role (Enterprise Manager)
- How to remove an application role (Enterprise Manager)
- How to reveal or cancel announcement of SQL Server on a network (Windows)
- How to grant, deny, or revoke permissions on multiple objects to a user-defined role (Enterprise Manager)
-
Monitoring Server Performance and Activity
- How to start SQL Profiler (Enterprise Manager)
- How to view current server activity (Enterprise Manager)
- How to view the last command batch for a connection (Enterprise Manager)
- How to view the current locks (Enterprise Manager)
- How to send a message to a currently connected user (Enterprise Manager)
- How to terminate a process (Enterprise Manager)
- How to view the SQL Server error log (Enterprise Manager)
- How to start Performance Monitor (Windows)
- How to start System Monitor (Windows)
- How to set up a SQL Server database alert (Windows NT)
- How to set up a SQL Server database alert (Windows 2000)
- How to view the Windows application log (Windows)
- How to enable SQL Server support of SNMP on Windows 98 (Windows)
- How to copy the SQL Server MSSQL-MIB to an SNMP workstation (Windows)
- How to set trace definition defaults (SQL Profiler)
- How to set trace display defaults (SQL Profiler)
- How to create a trace (SQL Profiler)
- How to add or remove events from a trace template or trace file (SQL Profiler)
- How to add or remove data columns from a trace template (SQL Profiler)
- How to filter events in a trace template (SQL Profiler)
- How to save trace results to a file (SQL Profiler)
- How to save trace results to a table (SQL Profiler)
- How to modify a trace template (SQL Profiler)
- How to pause a trace (SQL Profiler)
- How to run a trace after it has been paused or stopped (SQL Profiler)
- How to clear a trace window (SQL Profiler)
- How to close a trace window (SQL Profiler)
- How to stop a trace (SQL Profiler)
- How to view filter information (SQL Profiler)
- How to open a trace data file (SQL Profiler)
- How to open a trace table (SQL Profiler)
- How to replay a trace table (SQL Profiler)
- How to replay a trace file (SQL Profiler)
- How to replay a single event at a time (SQL Profiler)
- How to replay to a breakpoint (SQL Profiler)
- How to replay to the cursor (SQL Profiler)
- How to replay an SQL script (SQL Profiler)
- How to modify a filter (SQL Profiler)
- How to set a maximum file size for a trace file (SQL Profiler)
- How to set a maximum table size for a trace table (SQL Profiler)
- How to set an immediate start time for traces (SQL Profiler)
- How to set a StartTime filter for a trace (SQL Profiler)
- How to set an EndTime filter for a trace (SQL Profiler)
- How to filter system IDs in a trace (SQL Profiler)
- How to create a trace template (SQL Profiler)
- How to set global trace options (SQL Profiler)
- How to find a value or data column while tracing (SQL Profiler)
- How to launch a new trace with the current template (SQL Profiler)
- How to derive a template from a running trace (SQL Profiler)
- How to derive a template from a trace file or trace table (SQL Profiler)
- How to save a template, trace file, or trace table to SQL Script (SQL Profiler)
- How to create an SQL Script for a running trace (SQL Profiler)
-
Creating and Maintaining Databases
-
Databases
- How to create a database (Enterprise Manager)
- How to create a database using the Create Database Wizard (Enterprise Manager)
- How to increase the size of a database (Enterprise Manager)
- How to shrink a database (Enterprise Manager)
- How to delete data or log files from a database (Enterprise Manager)
- How to change the configuration settings for a database (Enterprise Manager)
- How to view a database (Enterprise Manager)
- How to view the settings for a database (Enterprise Manager)
- How to view a list of databases on a server (Enterprise Manager)
- How to display data and log space information for a database (Enterprise Manager)
- How to generate a script (Enterprise Manager)
- How to start the Database Maintenance Plan Wizard (Enterprise Manager)
- How to delete a database (Enterprise Manager)
- How to attach and detach a database (Enterprise Manager)
- How to create user-defined data types (Enterprise Manager)
- How to delete user-defined data types (Enterprise Manager)
- How to create a reflexive relationship (Enterprise Manager)
- How to create a many-to-many relationship between tables (Enterprise Manager)
- How to delete a relationship (Enterprise Manager)
- How to create a DEFAULT object (Enterprise Manager)
- How to delete a DEFAULT object (Enterprise Manager)
- How to view the dependencies of a table (Enterprise Manager)
- Indexes
-
Views
- How to create a view using the Create View Wizard (Enterprise Manager)
- How to rename a view (Enterprise Manager)
- How to modify a view (Enterprise Manager)
- How to get information about a view (Enterprise Manager)
- How to display the dependencies of a view (Enterprise Manager)
- How to delete a view (Enterprise Manager)
-
Stored Procedures
- How to create a stored procedure (Enterprise Manager)
- How to create a stored procedure using the Create Stored Procedure Wizard (Enterprise Manager)
- How to add an extended stored procedure (Enterprise Manager)
- How to modify a stored procedure (Enterprise Manager)
- How to rename a stored procedure (Enterprise Manager)
- How to view the definition of a stored procedure (Enterprise Manager)
- How to view the dependencies of a stored procedure (Enterprise Manager)
- How to view information about an extended stored procedure (Enterprise Manager)
- How to delete a stored procedure (Enterprise Manager)
- How to delete an extended stored procedure (Enterprise Manager)
- Triggers
-
Full-text Indexes
- How to enable a database for full-text indexing (Enterprise Manager)
- How to enable a table for full-text indexing (Enterprise Manager)
- How to enable a column for full-text indexing (Enterprise Manager)
- How to edit a full-text index on a table (Enterprise Manager)
- How to remove full-text indexing on a table (Enterprise Manager)
- How to create a full-text catalog (Enterprise Manager)
- How to rebuild a full-text catalog (Enterprise Manager)
- How to rebuild all full-text catalogs in a database (Enterprise Manager)
- How to start and stop a full or incremental population of a full-text index (Enterprise Manager)
- How to check the status, tables, and schedules of a full-text catalog (Enterprise Manager)
- How to change or create a new schedule for a full-text catalog (Enterprise Manager)
- How to remove a full-text catalog from a database (Enterprise Manager)
- How to remove all full-text catalogs in a database (Enterprise Manager)
- How to repopulate all full-text catalogs for a database (Enterprise Manager)
- How to clean up the full-text catalogs on a server (Enterprise Manager)
- How to start and stop the Microsoft Search Service for full-text support (Enterprise Manager)
-
Databases
- Accessing and Changing Data
- Optimizing Database Performance
-
Replication
- Replication Types (Enterprise Manager)
-
Replication Tools (Enterprise Manager)
- How to open Publisher and Distributor properties (Enterprise Manager)
- How to open publication properties (Enterprise Manager)
- How to open push subscription properties (Enterprise Manager)
- How to open pull subscription properties (Enterprise Manager)
- How to open agent properties (Enterprise Manager)
- How to open Windows Synchronization Manager
-
Implementing Replication (Enterprise Manager)
- How to configure publishing and distribution (Enterprise Manager)
- How to modify Publisher and Distributor properties (Enterprise Manager)
- How to add, modify, or disable a Subscriber (Enterprise Manager)
- How to disable publishing and distribution (Enterprise Manager)
- How to create publications and define articles (Enterprise Manager)
- How to modify publications and articles (Enterprise Manager)
- How to delete publications and articles (Enterprise Manager)
- How to create a push subscription (Enterprise Manager)
- How to modify a push subscription (Enterprise Manager)
- How to delete a push subscription (Enterprise Manager)
- How to create a pull or anonymous subscription (Enterprise Manager)
- How to view or modify pull or anonymous subscriptions (Enterprise Manager)
- How to delete a pull or anonymous subscription (Enterprise Manager)
- How to create an anonymous subscription (Windows Synchronization Manager)
- How to view or modify the default snapshot folder location (Enterprise Manager)
- How to specify alternate snapshot locations (Enterprise Manager)
- How to compress and deliver snapshot files (Enterprise Manager)
- How to set the - UseInprocLoader property (Enterprise Manager)
- How to execute scripts before and after the snapshot is applied (Enterprise Manager)
- How to reinitialize a subscription (Enterprise Manager)
- How to browse and copy snapshot files (Enterprise Manager)
- How to synchronize a subscription (Enterprise Manager)
- How to synchronize an anonymous subscription (Windows Synchronization Manager)
- How to view and resolve merge synchronization conflicts (Enterprise Manager)
- How to script replication (Enterprise Manager)
- How to apply schema changes on publication databases (Enterprise Manager)
- How to specify FTP information (Enterprise Manager)
-
Replication Options (Enterprise Manager)
- How to filter publications horizontally using the Create Publication Wizard (Enterprise Manager)
- How to filter publications vertically using the Create Publication Wizard (Enterprise Manager)
- How to filter publications vertically using publication properties (Enterprise Manager)
- How to validate Subscriber information using the Create Publication Wizard (Enterprise Manager)
- How to filter publications horizontally using publication properties (Enterprise Manager)
- How to create a dynamic snapshot (Enterprise Manager)
- How to filter with a user-defined function using the Create Publication Wizard (Enterprise Manager)
- How to filter with a user-defined function using publication properties (Enterprise Manager)
- How to drop all subscriptions to a publication (Enterprise Manager)
- How to install Message Queuing on the Distributor and Subscribers (Enterprise Manager)
- How to set the queued updating conflict resolution policy (Enterprise Manager)
- How to allow decentralized conflict reporting (Enterprise Manager)
- How to view conflicts (Enterprise Manager)
- How to enable immediate updating with queued updating as a failover (Enterprise Manager)
- How to switch from immediate updating to queued updating as a failover (Enterprise Manager)
- How to switch from immediate updating to queued updating as a failover (Transact-SQL)
- How to switch from immediate updating to queued updating as a failover (Windows Synchronization Manager)
- How to create a transformable subscription (Enterprise Manager)
- How to enable Subscribers to synchronize with alternate synchronization partners (Enterprise Manager)
- How to enable a Subscriber at an alternate synchronization partner (for named subscriptions) (Enterprise Manager)
- How to synchronize with alternate synchronization partners (Windows Synchronization Manager)
- How to synchronize pull subscriptions with alternate synchronization partners (Enterprise Manager)
- How to synchronize push subscriptions with alternate synchronization partners (Enterprise Manager)
- How to minimize the amount of data sent over the network during merge replication (Transact-SQL)
- How to configure a publication to allow copying of subscription databases (Enterprise Manager)
- How to copy a subscription database (Enterprise Manager)
- How to enable a Subscriber to receive published data (Enterprise Manager)
- How to attach a subscription database with named subscriptions (Enterprise Manager)
- How to attach a subscription database with anonymous subscriptions (Enterprise Manager)
-
Administering and Monitoring Replication (Enterprise Manager)
- How to change replication monitoring properties (Enterprise Manager)
- How to monitor replication agent history (Enterprise Manager)
- How to configure DCOM to run the Distribution Agent remotely
- How to configure DCOM to run the Merge Agent remotely
- How to enable a push subscription to use remote agent activation
- How to enable a pull subscription to use remote agent activation
- How to configure an existing subscription to use remote agent activation
- How to monitor replication agent performance (Enterprise Manager)
- How to create a replication agent profile (Enterprise Manager)
- Replication and Heterogeneous Data Sources (Enterprise Manager)
- Replication Security (Enterprise Manager)
-
Data Transformation Services
-
DTS Tools
- How to create a connection to Northwind in DTS Designer (Enterprise Manager)
- How to create a second connection to the Northwind database using DTS Designer (Enterprise Manager)
- How to copy data from a Northwind table using DTS Designer (Enterprise Manager)
- How to configure an Execute SQL task to drop and re-create a destination table (Enterprise Manager)
- How to configure workflow in the Execute SQL task (Enterprise Manager)
- How to save the DTS package to a SQL Server msdb table (Enterprise Manager)
- How to access a DTS package template (Enterprise Manager)
- How to create and save a DTS package template (Enterprise Manager)
-
DTS Package Elements
- How to create a Transform Data task (Enterprise Manager)
- How to configure the connections for a Transform Data task (Enterprise Manager)
- How to configure a new transformation for a Transform Data task (Enterprise Manager)
- How to activate the multiphase data pump feature (Enterprise Manager)
- How to add a multiphase data pump transformation function using an ActiveX script (Enterprise Manager)
- How to call a COM object that customizes one or more data pump phases (Enterprise Manager)
- How to enable the Transform Data task fast load options (Enterprise Manager)
- How to configure the fast load batch options (Enterprise Manager)
- How to configure the data pump exception files (Enterprise Manager)
- How to add a DTS task to a DTS package (Enterprise Manager)
- How to add the Bulk Insert task to a DTS package (Enterprise Manager)
- How to add the Execute SQL task to a DTS package (Enterprise Manager)
- How to execute a stored procedure with an input parameter (Enterprise Manager)
- How to save row values into global variables (Enterprise Manager)
- How to retrieve the row value data (Enterprise Manager)
- How to save an entire rowset into a global variable (Enterprise Manager)
- How to retrieve rowset data stored in a global variable (Enterprise Manager)
- How to send a message with the Message Queue task (Enterprise Manager)
- How to receive a string message with the Message Queue task (Enterprise Manager)
- How to receive a Data File Message with the Message Queue task (Enterprise Manager)
- How to receive a global variables message with the Message Queue task (Enterprise Manager)
- How to configure the Ask For Facts task (Enterprise Manager)
- How to configure the Wait For Trigger task (Enterprise Manager)
- How to create and configure Add New Employees (Enterprise Manager)
- How to configure the New Employee task (Enterprise Manager)
- How to configure the Transform Data task for Global Variable Messages (Enterprise Manager)
- How to configure the Log Bad Update task (Enterprise Manager)
- How to configure one Loop task (Enterprise Manager)
- How to create and configure the Load Expenses package (Enterprise Manager)
- How to configure the Spreadsheet Wait task (Enterprise Manager)
- How to configure the Delete Raw Data task (Enterprise Manager)
- How to configure the Load Raw Data task (Enterprise Manager)
- How to configure the Load Filtered Data task (Enterprise Manager)
- How to configure the Failed Expense Load (or Failed XLS Load) task (Enterprise Manager)
- How to create and configure three Loop tasks (Enterprise Manager)
- How to convert the format of a Date Time String transformation (Enterprise Manager)
- How to convert a string to lowercase characters (Enterprise Manager)
- How to convert a string to uppercase characters (Enterprise Manager)
- How to perform a Middle of String transformation (Enterprise Manager)
- How to perform a Trim String transformation (Enterprise Manager)
- How to perform a Read File transformation (Enterprise Manager)
- How to perform a Write File transformation (Enterprise Manager)
- How to create a connection (Enterprise Manager)
- How to create a data link with run-time resolution (Enterprise Manager)
-
DTS Package Management
- How to create a DTS package using DTS Designer (Enterprise Manager)
- How to create a DTS package using the DTS Import/Export Wizard (Enterprise Manager)
- How to edit a DTS package saved to SQL Server or Meta Data Services (Enterprise Manager)
- How to edit a DTS package saved to a structured storage file (Enterprise Manager)
- How to delete a DTS package (Enterprise Manager)
- How to execute a DTS package from SQL Server Enterprise Manager (Enterprise Manager)
- How to execute a DTS package from DTS Designer (Enterprise Manager)
- How to execute a DTS package from the DTS Import/Export Wizard (Enterprise Manager)
- How to execute a DTS package using the DTS Run utility (Command Prompt)
- How to execute a DTS package using dtsrun (Command Prompt)
- How to save a DTS package to SQL Server (Enterprise Manager)
- How to open a DTS package saved to SQL Server (Enterprise Manager)
- How to save a DTS package to Meta Data Services (Enterprise Manager)
- How to open a DTS package saved to Meta Data Services (Enterprise Manager)
- How to save a DTS package to a structured storage file (Enterprise Manager)
- How to open a DTS package saved to a structured storage file (Enterprise Manager)
- How to schedule a DTS package using the Schedule Package option (Enterprise Manager)
- How to schedule a DTS package using SQL Server Agent (Enterprise Manager)
- How to view or modify DTS package properties (Enterprise Manager)
- How to use Disconnected Edit to modify DTS package properties (Enterprise Manager)
- How to save a DTS package to a Visual Basic file (Enterprise Manager)
- How To View Package Logs (Enterprise Manager)
- How to Enable Package Logging (Enterprise Manager)
- How to set a DTS package password (Enterprise Manager)
- How to modify the persisting of authentication information (Enterprise Manager)
- How to select the Turn on just-in-time debugging option (Enterprise Manager)
- How to add ActiveX workflow scripts in DTS Designer (Enterprise Manager)
- How to execute a single package step in DTS Designer (Enterprise Manager)
-
DTS Tools
-
Administering SQL Server
-
Transact-SQL
-
Administering SQL Server
-
Backing Up and Restoring Databases
- How to create a database backup (Transact-SQL)
- How to restore a database backup (Transact-SQL)
- How to restart an interrupted backup operation (Transact-SQL)
- How to restart an interrupted restore operation (Transact-SQL)
- How to create a transaction log backup (Transact-SQL)
- How to backup the transaction log when the database is damaged (Transact-SQL)
- How to apply a transaction log backup (Transact-SQL)
- How to create a differential database backup (Transact-SQL)
- How to restore a differential database backup (Transact-SQL)
- How to recover a database without restoring (Transact-SQL)
- How to restore to the point of failure (Transact-SQL)
- How to set up, maintain, and bring online a standby server (Transact-SQL)
- How to restore to a point in time (Transact-SQL)
- How to restore the master database (Transact-SQL)
- How to back up files and filegroups (Transact-SQL)
- How to restore files and filegroups (Transact-SQL)
- How to restore files and filegroups over existing files (Transact-SQL)
- How to restore files to a new location (Transact-SQL)
- How to restore a database with a new name (Transact-SQL)
-
Managing Servers
- How to set up a remote server to allow the use of remote stored procedures (Transact-SQL)
- How to disable a remote server setup (Transact-SQL)
- How to set up and perform a log shipping role change (Transact-SQL)
- How to set up a Log Shipping Monitor (Transact-SQL)
- How to remove a log shipping pair from the Log Shipping Monitor (Transact-SQL)
- Automating Administrative Tasks
- Monitoring Server Performance and Activity
- Integrating SQL Server with Other Tools
-
Backing Up and Restoring Databases
-
Replication
- Replication Types
-
Implementing Replication (Transact-SQL)
- How to Configure Publishing and Distribution (Transact-SQL)
- How to Modify Publisher and Distributor Properties (Transact-SQL)
- How To Disable Publishing and Distribution (Transact-SQL)
- How to Create Publications and Define Articles (Transact-SQL)
- How to Modify Publications and Articles (Transact-SQL)
- How to Delete Publications and Articles (Transact-SQL)
- How to Create a Push Subscription (Transact-SQL)
- How to Modify a Push Subscription (Transact-SQL)
- How to Delete a Push Subscription (Transact-SQL)
- How to Create a Pull Subscription (Transact-SQL)
- How to View or Modify Pull or Anonymous Subscriptions (Transact-SQL)
- How to Delete a Pull Subscription (Transact-SQL)
- How to Create an Anonymous Subscription (Transact-SQL)
- How to Delete an Anonymous Subscription (Transact-SQL)
- How to Browse and Copy Snapshot Files (Transact-SQL)
- How to Apply Schema Changes on Publication Databases (Transact-SQL)
- How to Publish Data Over the Internet (Transact-SQL)
- Replication Options (Transact-SQL)
- Administering and Monitoring Replication (Transact-SQL)
- Replication Security (Transact-SQL)
-
Administering SQL Server
-
OLE DB
-
Processing Results (OLE DB)
- Execute stored procedure (using ODBC CALL syntax) and process return codes and output parameters (OLE DB)
- Execute stored procedure (using RPC syntax) and process return codes and output parameters (OLE DB)
- Execute user-defined function and process return code (OLE DB)
- How to fetch rows from a result set (OLE DB)
- Processing Large Data
- Enumerating OLE DB Data Sources
- Bulk-Copying Rowsets
- Obtaining a FAST_FORWARD cursor
- Using Bookmarks
- Fetching Columns Using IRow::GetColumns (or IRow::Open) and ISequentialStream
- Fetching Columns Using IRow::GetColumns (OLE DB)
- Setting XML as a Command Using ICommandStream and Retrieving the Results as an XML Document
-
Processing Results (OLE DB)
-
ODBC
- Configuring the SQL Server ODBC Driver (ODBC)
- Connecting to SQL Server (ODBC)
- Executing Queries (ODBC)
- Processing Results (ODBC)
- Using Cursors (ODBC)
- Performing Transactions (ODBC)
- Running Stored Procedures (ODBC)
- Managing text and image Columns (ODBC)
- Profiling ODBC Driver Performance (ODBC)
- How to process ODBC errors (ODBC)
- How to bulk copy with the SQL Server ODBC driver (ODBC)