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.
Gets the active replication settings for a database.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property ReplicationOptions As ReplicationOptions
Get
'Usage
Dim instance As Database
Dim value As ReplicationOptions
value = instance.ReplicationOptions
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public ReplicationOptions ReplicationOptions { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property ReplicationOptions ReplicationOptions {
ReplicationOptions get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member ReplicationOptions : ReplicationOptions
function get ReplicationOptions () : ReplicationOptions
Property Value
Type: Microsoft.SqlServer.Management.Smo.ReplicationOptions
A ReplicationOptions object value that specifies the active replication settings for the database.
Examples
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2012 database.
Dim db As Database
db = srv.Databases("AdventureWorks2012")
'Display information about the database.
Console.WriteLine("Name = " + db.Name.ToString)
Console.WriteLine("ID = " + db.ID.ToString)
Console.WriteLine("Owner = " + db.Owner.ToString)
Console.WriteLine("Parent = " + db.Parent.ToString)
Console.WriteLine("State = " + db.State.ToString)
Console.WriteLine("Status = " + db.Status.ToString)
Console.WriteLine("User Name = " + db.UserName.ToString)
Console.WriteLine("DBO Login = " + db.DboLogin.ToString)
Console.WriteLine("Version = " + db.Version.ToString)
Console.WriteLine("Service Broker = " + _
db.ServiceBroker.ToString)
Console.WriteLine("Replication Options = " + _
db.ReplicationOptions.ToString)
Console.WriteLine("Default File Group = " + _
db.DefaultFileGroup.ToString)
Console.WriteLine("Default FTS catalog = " + _
db.DefaultFullTextCatalog.ToString)
Console.WriteLine("Default Schema = " + _
db.DefaultSchema.ToString)
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")
Write-Host "Name =" $db.Name
Write-Host "ID =" $db.ID
Write-Host "Owner =" $db.Ownder
Write-Host "Parent =" $db.Parent
Write-Host "State =" $db.State
Write-Host "Status =" $db.Status
Write-Host "User Name =" $db.UserName
Write-Host "DBO Login =" $db.DboLogin
Write-Host "Version =" $db.Version
Write-Host "Service Broker =" $db.ServiceBroker
Write-Host "Replication Options =" $db.ReplicationOptions
Write-Host "Default File Group =" $db.DefaultFileGroup
Write-Host "Default FTS catalog =" $db.DefaultFullTextCatalog
Write-Host "Default Schema =" $db.DefaultSchema
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
Developer's Guide (Replication)