Prizes & Awards
My Profile
Active Members
TodayLast 7 Days
more...
|
 New Feature: Community Sites:
Create your own .NET community website and start earning from Google AdSense !
It's Free !
|
Command Prompt Utilities for sql2005
|
Introduction
Paragraph Heading 1
bcp Utility
Used to copy data from database to .dat files. you can backup data between an instance of Microsoft SQL Server and a data file in a user-specified format.
Example
Copying Table Rows into a Data File (with Mixed-Mode Authentication)
The following example illustrates the out option on the AdventureWorks.Sales.Currency table. This example creates a data file named Currency.dat and copies the table data into it using character format.
he example assumes that you are using mixed-mode authentication, you must use the -U switch to specify your login ID. Also, unless you are connecting to the default instance of SQL Server on the local computer, use the -S switch to specify the system name and, optionally, an instance name.
bcp AdventureWorks.Sales.Currency out Currency.dat -c -U -S
dta Utility
Used to analyze a workload and recommend physical design structures to optimize server performance for that workload.
use of this utility
1)Tune a workload that includes indexes and indexed views in its recommendation
2)Limit disk use
3)Limit the number of tuned queries
4)Tune specific tables listed in a file
dtexec Utility
The dtexec command prompt utility is used to configure and execute SQL Server 2005 Integration Services (SSIS) packages. The dtexec utility provides access to all the package configuration and execution features, such as connections, properties, variables, logging, and progress indicators.
use
1)Running Packages
2)Logging Option
3)set options
dtutil Utility
The dtutil command prompt utility is used to manage SQL Server 2005 Integration Services (SSIS) packages. The utility can copy, move, delete, or verify the existence of a package. These actions can be performed on any SSIS package that is stored in one of three locations: a Microsoft SQL Server database, the SSIS Package Store, and the file system.
use
1)Exists Examples
2)copy Examples
3)delete Examples
4)Move Examples
5)sign Examples
6)Encrypt Examples
Some more commands
Microsoft.AnalysisServices.Deployment Utility
Used to deploy Analysis Services projects to instances of Analysis Services.The Microsoft.AnalysisServices.Deployment utility lets you start the Microsoft SQL Server 2005 Analysis Services (SSAS) deployment engine from the command prompt. As input file, the utility uses the XML output files generated by building an Analysis Services project in Business Intelligence Development Studio.
nscontrol Utility
The nscontrol utility is a command prompt utility for administering Microsoft SQL Server 2005 Notification Services. It provides commands for deploying, configuring, monitoring, and controlling Notification Services instances and applications.
osql Utility
The osql utility allows you to enter Transact-SQL statements, system procedures, and script files. This utility uses ODBC to communicate with the server.
profiler90 Utility
The profiler90 utility launches the SQL Server Profiler tool. The optional arguments listed later in this topic allow you to control how the application starts.
rs Utility
Processes script you provide in an input file. Use this utility to automate report server deployment and administration tasks.
rsconfig Utility
The rsconfig utility (Rsconfig.exe) encrypts and stores connection and account values in the RSReportServer.config file. Encrypted values include report server database connection information and account values used for unattended report processing.
rskeymgmt Utility
Extracts, restores, creates, and deletes the symmetric key used to protect sensitive report server data against unauthorized access. This utility is also used to join report server instances in a scale-out deployment. A report server scale-out deployment refers to multiple report server instances that share a single report server database.
sac Utility
The sac utility imports and exports Microsoft SQL Server 2005 surface area settings. Using this utility, you can configure the surface area on one computer, and then apply the same settings to other computers.
sqlagent90 Application
The sqlagent90 application starts SQL Server Agent from the command prompt. Usually, SQL Server Agent should be run from SQL Server Management Studio or by using SQL-SMO methods in an application. Only run sqlagent90 from the command prompt when you are diagnosing SQL Server Agent, or when you are directed to it by your primary support provider.
sqlcmd Utility
The sqlcmd utility allows you to enter Transact-SQL statements, system procedures, and script files at the command prompt. This utility uses OLE DB to execute Transact-SQL batches.
SQLdiag Utility
In Microsoft SQL Server 2005, the SQLdiag utility is a general purpose diagnostics collection utility that can be run as a console application or as a service. You can use SQLdiag to collect logs and data files from SQL Server and other types of servers, and use it to monitor your servers over time or troubleshoot specific problems with your servers.
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.
Summary
|
Responses
|
No responses found. Be the first to respond and make money from revenue sharing program.
|
|