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 |