documentation
.HELP!
How to Install SQL Server 2000 Documentation
How to execute a single package step in DTS Designer (Enterprise Manager)
How to Install SQL Server 2000
previous page
next page
How To
How to execute a single package step in DTS Designer (Enterprise Manager)
To execute a single package step in DTS Designer
On the
Task
toolbar, right-click the task you want to execute.
Click
Execute Step
.
previous page
start
next page
Menu
Homepage
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
How to analyze a query using Index Analysis (Query Analyzer)
How to analyze a query using Index Tuning Wizard (Query Analyzer)
How to create an index using the Create Index Wizard (Enterprise Manager)
How to view all indexes in a database (Enterprise Manager)
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
How to create a trigger (Enterprise Manager)
How to modify a trigger (Enterprise Manager)
How to view a trigger (Enterprise Manager)
How to view the dependencies of a trigger (Enterprise Manager)
How to delete a trigger (Enterprise Manager)
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)
Accessing and Changing Data
How to access the Query Designer in Data Transformation Services (Enterprise Manager)
Optimizing Database Performance
Database Design
How to place an existing table on a different filegroup (Enterprise Manager)
How to place an existing index on a different filegroup (Enterprise Manager)
Query Tuning
How to create statistics (Query Analyzer)
How to update statistics (Query Analyzer)
How to delete statistics (Query Analyzer)
How to create a new index (Query Analyzer)
How to modify an index (Query Analyzer)
How to delete an index (Query Analyzer)
Replication
Replication Types (Enterprise Manager)
How to enable activation of the Interactive Resolver (Enterprise Manager)
To activate the Interactive Resolver during a merge synchronization (Windows Synchronization Manager)
How to set row- or column-level tracking for an article (Enterprise Manager)
How to choose a resolver (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)
How to publish to heterogeneous Subscribers (Enterprise Manager)
How to enable a Jet 4.0 database as a Subscriber (Enterprise Manager)
How to create a publication for a Jet 4.0 Subscriber (Enterprise Manager)
How to add a push subscription to a Jet 4.0 Subscriber (Enterprise Manager)
Replication Security (Enterprise Manager)
How to change the login property of a pull subscription
How to add or change a password on a Distributor
To grant or revoke access to a publication
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)
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
How to create a job (Transact-SQL)
How to create a master SQL Server Agent job (Transact-SQL)
How to modify a master SQL Server Agent job (Transact-SQL)
How to create an operator (Transact-SQL)
How to modify an operator (Transact-SQL)
Monitoring Server Performance and Activity
How to create a trace (Transact-SQL)
How to set a trace filter (Transact-SQL)
How to modify an existing trace (Transact-SQL)
How to view a saved trace (Transact-SQL)
How to view filter information (Transact-SQL)
How to delete a trace (Transact-SQL)
Integrating SQL Server with Other Tools
How to create an OLE Automation object (Transact-SQL)
How to debug a custom OLE Automation server (Transact-SQL)
How to use SQL Mail (Transact-SQL)
Replication
Replication Types
How to set row- or column-level tracking for an article (Transact-SQL)
How to choose a resolver (Transact-SQL)
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)
How to validate Subscriber information (Transact-SQL)
Administering and Monitoring Replication (Transact-SQL)
How to create a replication agent profile (Transact-SQL)
Replication Security (Transact-SQL)
How to add or change a password on a Distributor
To grant or revoke access to a publication
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
How to set large data (OLE DB)
Enumerating OLE DB Data Sources
How to enumerate OLE DB data sources (OLE DB)
Bulk-Copying Rowsets
How to bulk copy data using IRowsetFastLoad (OLE DB)
Obtaining a FAST_FORWARD cursor
How to obtain FAST_FORWARD cursor
Using Bookmarks
How to retrieve rows using bookmarks (OLE DB)
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
ODBC
Configuring the SQL Server ODBC Driver (ODBC)
How to add a data source (ODBC)
How to delete a data source (ODBC)
How to upgrade the catalog stored procedures
Connecting to SQL Server (ODBC)
How to allocate handles and connect to SQL Server (ODBC)
Executing Queries (ODBC)
How to use a statement (ODBC)
How to set cursor options (ODBC)
How to execute a statement directly (ODBC)
How to prepare and execute a statement (ODBC)
Processing Results (ODBC)
How to retrieve result set information (ODBC)
How to process results (ODBC)
Using Cursors (ODBC)
How to use cursors (ODBC)
How to use rowset binding (ODBC)
How to fetch and update rowsets (ODBC)
Performing Transactions (ODBC)
How to use Microsoft Distributed Transaction Coordinator (ODBC)
Running Stored Procedures (ODBC)
How to call stored procedures (ODBC)
How to process return codes and output parameters (ODBC)
Managing text and image Columns (ODBC)
How to use data-at-execution parameters (ODBC)
How to use data-at-execution columns (ODBC)
Profiling ODBC Driver Performance (ODBC)
How to profile driver performance data (ODBC)
How to log long-running queries (ODBC)
How to process ODBC errors (ODBC)
How to bulk copy with the SQL Server ODBC driver (ODBC)
How to bulk copy without a format file (ODBC)
How to bulk copy a SELECT result set (ODBC)
How to create a bulk copy format file (ODBC)
How to bulk copy by using a format file (ODBC)
How to bulk copy data from program variables (ODBC)
Get in touch
Submit feedback about this site to:
[email protected]