BackupRestoreBase.ExecuteSql Method

Executes a batch of Transact-SQL statements 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

'Declaration
Protected Sub ExecuteSql ( _
    server As Server, _
    queries As StringCollection _
)
'Usage
Dim server As Server 
Dim queries As StringCollection 

Me.ExecuteSql(server, queries)

protected void ExecuteSql(
    Server server,
    StringCollection queries
)

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

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

protected function ExecuteSql(
    server : Server, 
    queries : 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

Backing Up and Restoring Databases and Transaction Logs

See Also

Reference

BackupRestoreBase Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

RESTORE (Transact-SQL)

BACKUP (Transact-SQL)