SQL server 2005 utilities

SQL server 2005 utilities:

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





bcp Utility

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


dta Utility

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


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.


dtutil Utility

 Used to manage SSIS packages.


Microsoft.AnalysisServices.Deployment Utility

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


nscontrol Utility

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


osql Utility

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


profiler90 Utility

 Used to start SQL Server Profiler from a command prompt.


rs Utility

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


rsconfig Utility

 Used to configure a report server connection.


rskeymgmt Utility

 Used to manage encryption keys on a report server.


sac Utility

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


sqlagent90 Application

 Used to start SQL Server Agent from a command prompt.


sqlcmd Utility

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


SQLdiag Utility

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


sqlmaint Utility

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


sqlservr Application

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


sqlwb Utility

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


tablediff Utility

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



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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s