BackupRestoreBase.ExecuteSqlAsync Method (Server, StringCollection)

Applies To: SQL Server 2016 Preview

Executes a batch of Transact-SQL statements asynchronously that does not expect a returned results set on the specified instance of SQL Server.

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

Syntax

protected void ExecuteSqlAsync(
    Server server,
    StringCollection queries
)

protected:
void ExecuteSqlAsync(
    Server^ server,
    StringCollection^ queries
)

member ExecuteSqlAsync : 
        server:Server *
        queries:StringCollection -> unit

Protected Sub ExecuteSqlAsync (
    server As Server,
    queries As StringCollection
)

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.

• queries
  Type: System.Collections.Specialized.StringCollection

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

Examples

Legacy Code Example

Backing Up and Restoring Databases and Transaction Logs

See Also

BackupRestoreBase Class
Microsoft.SqlServer.Management.Smo Namespace
RESTORE (Transact-SQL)
BACKUP (Transact-SQL)

Return to top