SQL Server 2005 Command prompt utility

Source: Internet
Author: User
Tags microsoft sql server sql management studio sql server management sql server management studio microsoft customer service ssis

This article summarizes the SQL Server 2005 Command prompt utility for reference learning applications.

Practical Tools Description Installation location

bcp utility

Used to copy data between a Microsoft SQL Server instance and a data file in a user-specified format.

X:program FilesMicrosoft SQL Server90toolsbinn

DTA Utility

Used to analyze workloads and recommend physical design structures to optimize server performance under this workload.

X:program FilesMicrosoft SQL Server90toolsbinn

dtexec Utility Tool

Used to configure and execute SQL Server integration Services (SSIS) packages. The user interface version of the command prompt utility, called DTExecUI, provides the Execute Package utility.

X:program FilesMicrosoft SQL Server90dtsbinn

DTUtil Utility Tool

Used to manage SSIS packages.

X:program FilesMicrosoft SQL Server90dtsbinn

Microsoft.AnalysisServices.Deployment Utility Tool

Used to deploy an Analysis Services project to an Analysis Services instance.

X:program FilesMicrosoft SQL Servermssql.2olapin

NSControl Utility tool

Used to create, delete, and manage Notification Services instances.

X:program FilesMicrosoft SQL Server90notificationservices.n.nnnin

osql Utility Tool

You can enter Transact-SQL statements, system procedures, and script files at the command prompt.

X:program FilesMicrosoft SQL Server90toolsbinn

Profiler90 Utility Tool

Use to start SQL Server Profiler at the command prompt.

X:program FilesMicrosoft SQL Server90toolsbinn

RS Utility

Used to run scripts that specialize in managing Reporting Services report servers.

X:program FilesMicrosoft SQL Server90toolsbinn

RSConfig Configuration Tool

Used to configure a report server connection.

X:program FilesMicrosoft SQL Server90toolsbinn

SKEYMGMT Utility Tool

Used to manage encryption keys on the report server.

X:program FilesMicrosoft SQL Server90toolsbinn

SAC Utility

Used to import or export the perimeter application configurator settings between instances of SQL Server 2005.

X:program FilesMicrosoft SQL server90shared

SQLAGENT90 applications

Use to start the SQL Server Agent at the command prompt.

X:program FilesMicrosoft SQL Server<instance_name>mssqlbinn

sqlcmd Utility

You can enter Transact-SQL statements, system procedures, and script files at the command prompt.

X:program FilesMicrosoft SQL Server90toolsbinn

SQLdiag Utility Tool

Used to collect diagnostic information for Microsoft customer service and support departments.

X:program FilesMicrosoft SQL Server90toolsbinn

sqlmaint Utility Tool

Used to perform database maintenance plans created by previous versions of SQL Server.

X:program FilesMicrosoft SQL Servermssql.1mssqlbinn

sqlservr Applications

Used to start and stop instances of the database engine at the command prompt for troubleshooting.

X:program FilesMicrosoft SQL Servermssql.1mssqlbinn

SQLWB Utility Tool

Used to start SQL Server Management Studio at the command prompt.

X:program FilesMicrosoft SQL Server90toolsbinnvsshellcommon7ide

Tablediff Utility Tool

Used to compare data in two tables to see if the data is not convergent, which is useful for troubleshooting replication topology failures.

X:program FilesMicrosoft SQL server90com



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.