For Partners

Automated Build Studio/support/viewarticle.aspx?aid=9302
	Introduction/support/viewarticle.aspx?aid=9304
	Getting Started/support/viewarticle.aspx?aid=9312
	Working With Automated Build Studio/support/viewarticle.aspx?aid=9325
	Operations Reference/support/viewarticle.aspx?aid=9623
		Common Operation Properties/support/viewarticle.aspx?aid=9386
		.NET Tools/support/viewarticle.aspx?aid=9933
		ADO/support/viewarticle.aspx?aid=10368
		Archivers/support/viewarticle.aspx?aid=9794
		Authenticode/support/viewarticle.aspx?aid=10217
		AutomatedQA Tools/support/viewarticle.aspx?aid=10098
		Borland Compilers/support/viewarticle.aspx?aid=9679
		Build Tools/support/viewarticle.aspx?aid=10156
		Burn CD/DVD/support/viewarticle.aspx?aid=10301
		Communication/support/viewarticle.aspx?aid=10094
		Concurrent Versions System/support/viewarticle.aspx?aid=9634
		Creating Custom Operations/support/viewarticle.aspx?aid=9517
		Encrypting File System/support/viewarticle.aspx?aid=10352
		Execute/support/viewarticle.aspx?aid=10365
		Files and Directories/support/viewarticle.aspx?aid=10107
		Frequently Used/support/viewarticle.aspx?aid=10195
		FTP/support/viewarticle.aspx?aid=10093
		Help Compilers/support/viewarticle.aspx?aid=10109
		HTTP/support/viewarticle.aspx?aid=10092
		Installers/support/viewarticle.aspx?aid=9795
		Interactive/support/viewarticle.aspx?aid=9504
		Internet Information Services (IIS)/support/viewarticle.aspx?aid=9964
		Issue Tracking/support/viewarticle.aspx?aid=9472
		JediVCS/support/viewarticle.aspx?aid=9949
		Logging/support/viewarticle.aspx?aid=10210
		Mercurial/support/viewarticle.aspx?aid=10353
		Microsoft Compilers/support/viewarticle.aspx?aid=9676
		Microsoft Compilers for Smart Device/support/viewarticle.aspx?aid=9675
		Microsoft Source Server/support/viewarticle.aspx?aid=10291
		Microsoft SQL Server/support/viewarticle.aspx?aid=9882
		Microsoft Virtual PC/support/viewarticle.aspx?aid=10015
		Microsoft Virtual Server/support/viewarticle.aspx?aid=9508
		Microsoft Visual SourceSafe/support/viewarticle.aspx?aid=9626
		Misc/support/viewarticle.aspx?aid=10263
		MySQL/support/viewarticle.aspx?aid=9885
		Oracle/support/viewarticle.aspx?aid=10203
		Other Compilers/support/viewarticle.aspx?aid=9677
		Patch Management/support/viewarticle.aspx?aid=10167
		Perforce/support/viewarticle.aspx?aid=9624
		Prepare Code/support/viewarticle.aspx?aid=10134
		PsTools/support/viewarticle.aspx?aid=9720
		PVCS/support/viewarticle.aspx?aid=9632
		Rational ClearCase/support/viewarticle.aspx?aid=9629
		Read/Write/support/viewarticle.aspx?aid=10241
		Remote Macro Execution/support/viewarticle.aspx?aid=9369
		Serena Dimensions/support/viewarticle.aspx?aid=10364
		Source Code Tools/support/viewarticle.aspx?aid=10194
		SourceGear Vault/support/viewarticle.aspx?aid=9625
		SourceOffSite/support/viewarticle.aspx?aid=9633
		Standard/support/viewarticle.aspx?aid=10212
		StarTeam/support/viewarticle.aspx?aid=9622
		String Manipulation/support/viewarticle.aspx?aid=10308
		Subversion/support/viewarticle.aspx?aid=9628
		Surround SCM/support/viewarticle.aspx?aid=9621
		Team Coherence/support/viewarticle.aspx?aid=9471
		Team Foundation Version Control/support/viewarticle.aspx?aid=9608
		Unit Tests/support/viewarticle.aspx?aid=10115
		VMWare Server/support/viewarticle.aspx?aid=10008
		VMWare Workstation/support/viewarticle.aspx?aid=9913
		Wait/support/viewarticle.aspx?aid=9994
		WMI/support/viewarticle.aspx?aid=10136
		XML/support/viewarticle.aspx?aid=9702
		User Interface Actions/support/viewarticle.aspx?aid=10346
	Technical Support and Resources/support/viewarticle.aspx?aid=9314

Updated: 6/10/2010 Applies To: Automated Build Studio 6

Rating: No votes

Click to rate:

Full-Screen mode

Operations

Microsoft SQL Server Operations

The Microsoft SQL Server category includes the following operations:

Operation	Description
Back Up Database	Backs up the specified Microsoft SQL Server database.
Check Database	Checks the integrity of objects in the specified Microsoft SQL Server database.
Clean Up Database	Removes unused space from the specified Microsoft SQL Server database.
Execute DTSRun	Executes the specified DTS package.
Execute Stored Procedure	Executes the specified stored procedure from a particular Microsoft SQL Server database which is accessed via ADO.
Execute SQL Script	Runs an SQL script that accesses a Microsoft SQL Server instance which is accessed via ADO.
Execute SQL Statement	Executes an SQL query against the specified Microsoft SQL Server database which is accessed via ADO.
Rebuild Indexes	Rebuilds indexes on tables in the specified Microsoft SQL Server database.
Restore Database	Restores the specified Microsoft SQL Server database from the backup file.
Run SQL Server 2000 Best Practices Analyzer	Uses Microsoft SQL Server 2000 Best Practices Analyzer to verify whether common best practices are implemented in the specified Microsoft SQL Server database.
Run SQL Server 2005 Best Practices Analyzer	Uses Microsoft SQL Server 2005 Best Practices Analyzer to verify whether common best practices are implemented in the specified Microsoft SQL Server database.
Update Statistics	Updates information about distribution of key values in the specified Microsoft SQL Server database.

In order for the desired Microsoft SQL Server operation to execute successfully, Microsoft SQL Server 2000 with Service Pack 3, Microsoft SQL Server 2005 or Microsoft SQL Server 2008 must be installed on the target computer that hosts the desired SQL Server instance. Otherwise, an error will occur.

See also

List of Operations

Send feedback on this document