Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following table contains a list of command prompt utilities that ship with Microsoft SQL Server 2005.
| Utility | Description | Installed in |
|---|---|---|
Used to copy data between an instance of Microsoft SQL Server and a data file in a user-specified format. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn |
|
Used to analyze a workload and recommend physical design structures to optimize server performance for that workload. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn |
|
Used to configure and execute a SQL Server 2005 Integration Services (SSIS) (SSIS) package. A user interface version of this command prompt utility is called DTExecUI, which brings up the Execute Package Utility. |
x:\Program Files\Microsoft SQL Server\90\DTS\Binn |
|
Used to manage SSIS packages. |
x:\Program Files\Microsoft SQL Server\90\DTS\Binn |
|
Used to deploy Analysis Services projects to instances of Analysis Services. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn\VShell\Common7\IDE |
|
Used to create, delete, and manage instances of Notification Services. |
x:\Program Files\Microsoft SQL Server\90\NotificationServices\n.n.nnn\bin |
|
Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn |
|
Used to start SQL Server Profiler from a command prompt. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn |
|
Used to run scripts designed for managing Reporting Services report servers. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn |
|
Used to configure a report server connection. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn |
|
Used to manage encryption keys on a report server. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn |
|
Used to import or export surface area configuration settings between instances of SQL Server 2005. |
x:\Program Files\Microsoft SQL Server\90\Shared |
|
Used to start SQL Server Agent from a command prompt. |
x:\Program Files\Microsoft SQL Server\<instance_name>\MSSQL\Binn |
|
Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn |
|
Used to collect diagnostic information for Microsoft Customer Service and Support. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn |
|
Used by applications to perform backup, copy, and restore operations and associated clean-up tasks for a log shipping configuration without running the backup, copy, and restore jobs. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn |
|
Used to execute database maintenance plans created in previous versions of SQL Server. |
x:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn |
|
Used to start and stop an instance of Database Engine from the command prompt for troubleshooting. |
x:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn |
|
Used to start SQL Server Management Studio from a command prompt. |
x:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE |
|
Used to compare the data in two tables for non-convergence, which is useful when troubleshooting a replication topology. |
x:\Program Files\Microsoft SQL Server\90\COM |
| Convention | Used for |
|---|---|
UPPERCASE |
Statements and terms used at the operating system level. |
|
Sample commands and program code. |
italic |
User-supplied parameters. |
bold |
Commands, parameters, and other syntax that must be typed exactly as shown. |
Replication Distribution Agent
Replication Log Reader Agent
Replication Merge Agent
Replication Queue Reader Agent
Replication Snapshot Agent
Getting SQL Server 2005 Assistance
| Release | History |
|---|---|
17 July 2006 |
|