Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
- subscriberSecurity
Type: Microsoft.SqlServer.Replication.ConnectionSecurityContext
A ConnectionSecurityContext that specifies the connection context that is used to establish a connection with the Subscriber.
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).