BackupRestoreBase.ExecuteSqlWithResults Method

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.

Community Additions

ADD
Show: