SQL Server 2005 Command prompt utility

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