LinkedServer.Location Property

Gets or sets the description of the location of the linked server.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone)> _
Public Property Location As String 
    Get 
    Set
'Usage
Dim instance As LinkedServer 
Dim value As String 

value = instance.Location

instance.Location = value

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

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone)]
public:
property String^ Location {
    String^ get ();
    void set (String^ value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)>]
member Location : string with get, set

function get Location () : String 
function set Location (value : String)

Property Value

Type: System.String
A String value that specifies the location of the linked server.

Remarks

Server names often do not reveal their physical location. The Location property is used to add a description of the physical location such as "Paris", or "Building 11".

Examples

Using Linked Servers in SMO

See Also

Reference

LinkedServer Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Linked Servers (Database Engine)

sp_addlinkedserver (Transact-SQL)