BackupRestoreBase.ExecuteSqlWithResults Method (Server, String)

 

Executes a batch of Transact-SQL statements that expects one or more returned results sets on the specified instance of SQL Server.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)

protected DataSet ExecuteSqlWithResults(
	Server server,
	string cmd
)

Parameters

server
Type: Microsoft.SqlServer.Management.Smo.Server

A Server object that specifies the instance of SQL Server on which to execute the batch of Transact-SQL statements.

cmd
Type: System.String

A StringCollection system object that contains the batch of Transact-SQL statements to be executed.

Return Value

Type: System.Data.DataSet

A DataSet system object that contains the results sets returned by the executed Transact-SQL command batch.

Return to top
Show: