SQL server 2005 utilities

SQL server 2005 utilities:

Suppose the SQL server installation folder: InstallationFolder\Microsoft SQL Server\

 

Utility

 Description

Subfolder

bcp Utility

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

 90\Tools\Binn

dta Utility

 Used to analyze a workload and recommend physical design structures to optimize server performance for that workload.

 90\Tools\Binn

dtexec Utility

 Used to configure and execute a SQL Server Integration Services (SSIS) package. A user interface version of this command prompt utility is called DTExecUI, which brings up the Execute Package Utility.

 90\DTS\Binn

dtutil Utility

 Used to manage SSIS packages.

 90\DTS\Binn

Microsoft.AnalysisServices.Deployment Utility

 Used to deploy Analysis Services projects to instances of Analysis Services.

MSSQL.2\OLAP\bin

nscontrol Utility

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

 90\NotificationServices\n.n.nnn\bin

osql Utility

 Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt.

 90\Tools\Binn

profiler90 Utility

 Used to start SQL Server Profiler from a command prompt.

 90\Tools\Binn

rs Utility

 Used to run scripts designed for managing Reporting Services report servers.

 90\Tools\Binn

rsconfig Utility

 Used to configure a report server connection.

 90\Tools\Binn

rskeymgmt Utility

 Used to manage encryption keys on a report server.

 90\Tools\Binn

sac Utility

 Used to import or export surface area configuration settings between instances of SQL Server 2005.

 90\Shared

sqlagent90 Application

 Used to start SQL Server Agent from a command prompt.

<instance_name>\MSSQL\Binn

sqlcmd Utility

 Allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt.

90\Tools\Binn

SQLdiag Utility

 Used to collect diagnostic information for Microsoft Customer Service and Support.

90\Tools\Binn

sqlmaint Utility

 Used to execute database maintenance plans created in previous versions of SQL Server.

MSSQL.1\MSSQL\Binn

sqlservr Application

 Used to start and stop an instance of Database Engine from the command prompt for troubleshooting.

MSSQL.1\MSSQL\Binn

sqlwb Utility

 Used to start SQL Server Management Studio from a command prompt.

90\Tools\Binn\VSShell\Common7\IDE

tablediff Utility

 Used to compare the data in two tables for non-convergence, which is useful when troubleshooting a replication topology.

90\COM

 

Advertisements
This entry was posted in SQL server 2005. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s