This topic has not yet been rated - Rate this topic

LinkedServer.DataSource Property

SQL Server 2012

Gets or sets the data source to be used when the linked server is made through a connection to an OLE DB provider.

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

Syntax

C++

JScript

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)]
public string DataSource { get; set; }

Property Value

Type: System.String
A String value that specifies the data source on the linked server.

Remarks

The data source is defined in by the OLE DB provider. For the OLE DB provider for SQL Server, it is the server name.

Examples

Using Linked Servers in SMO

Reference

LinkedServer Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Linked Servers (Database Engine)

sp_addlinkedserver (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD