ReplicationServer.AttachSubscriptionDatabase Method

Attaches a copied subscription database at the Subscriber.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public Sub AttachSubscriptionDatabase ( _
    databaseName As String, _
    fileName As String, _
    subscriberSecurity As ConnectionSecurityContext _
)
'Usage
Dim instance As ReplicationServer
Dim databaseName As String
Dim fileName As String
Dim subscriberSecurity As ConnectionSecurityContext

instance.AttachSubscriptionDatabase(databaseName, _
    fileName, subscriberSecurity)
public void AttachSubscriptionDatabase(
    string databaseName,
    string fileName,
    ConnectionSecurityContext subscriberSecurity
)
public:
void AttachSubscriptionDatabase(
    String^ databaseName, 
    String^ fileName, 
    ConnectionSecurityContext^ subscriberSecurity
)
member AttachSubscriptionDatabase : 
        databaseName:string * 
        fileName:string * 
        subscriberSecurity:ConnectionSecurityContext -> unit 
public function AttachSubscriptionDatabase(
    databaseName : String, 
    fileName : String, 
    subscriberSecurity : ConnectionSecurityContext
)

Parameters

  • databaseName
    Type: System.String
    A string value that specifies the name of the database being attached.
  • fileName
    Type: System.String
    A string value that specifies the complete path to, and the file name of, the data (.mdf) file being attached.

Exceptions

Exception Condition
ApplicationException

When the Subscriber is not running on SQL Server 2000 or later.

ArgumentException

If string parameters are null, contain null characters, or are too long.

If the subscriberSecurity parameter is null.

Remarks

The AttachSubscriptionDatabase method can be called by members of the sysadmin fixed server role.

The AttachSubscriptionDatabase method is equivalent to executing sp_attachsubscription (Transact-SQL).

This property is available with SQL Server 2000 and SQL Server 2005.

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.