Export (0) Print
Expand All

LinkedServer Properties

The LinkedServer type exposes the following members.

  Name Description
Public property Catalog Gets or sets the database to be used when the linked server is made through a connection to an OLE DB provider.
Public property CollationCompatible Gets or sets the Boolean property value that specifies whether the default collation of the linked server is compatible with the default collation on the local instance of SQL Server.
Public property CollationName Gets or sets the name of the collation to use when sorting data from the linked server.
Public property ConnectTimeout Gets or sets the number of seconds to wait for a connection to be established with the linked server before timing out.
Public property DataAccess Gets or sets the Boolean property value that specifies whether data can be accessed on the linked server.
Public property DataSource Gets or sets the data source to be used when the linked server is made through a connection to an OLE DB provider.
Public property DateLastModified Gets the date and time when the linked server was last modified.
Public property DistPublisher Gets or sets a Boolean property value that specifies whether the linked server is participating in replication as a distribution Publisher.
Public property Distributor Gets or sets a Boolean property value that specifies whether the linked server is participating in replication as a distribution Publisher.
Public property ID Gets the ID value that uniquely identifies the linked server.
Public property IsPromotionofDistributedTransactionsForRPCEnabled Gets or sets a Boolean property value that specifies whether the promotion of distributed transaction for RPC (remote procedure calls) is enabled.
Public property LazySchemaValidation Gets or sets the Boolean property value that specifies whether the schema used by the linked server data is validated when the local instance of SQL Server is idle or not.
Public property LinkedServerLogins Represents a collection of LinkedServerLogin objects. Each LinkedServerLogin object represents a linked server login defined on the linked server.
Public property Location Gets or sets the description of the location of the linked server.
Public property Name Gets or sets a String which contains the name of the LinkedServer. (Overrides NamedSmoObject.Name.)
Public property Parent Gets or sets the Server object that is the parent of the LinkedServer object.
Public property ProductName Gets or sets the name of the product to which SQL Server can connect through the OLE DB Provider.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property ProviderName Gets or sets the name of the OLE DB provider used to connect to the linked server.
Public property ProviderString Gets or sets the connection string used to connect to a linked server by way of the OLE DB Provider.
Public property Publisher Gets or sets a Boolean property value that specifies whether the linked server is a replication Publisher or not.
Public property QueryTimeout Gets or sets the time in seconds to wait for a query to execute before timing out.
Public property Rpc Gets or sets the Boolean property value that specifies whether the linked server supports remote procedure calls (RPCs).
Public property RpcOut The Boolean property value that specifies whether the linked server supports remote procedure calls (RPCs) with output parameters.
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property Subscriber Gets or sets the Boolean property value that specifies whether the linked server is a replication Subscriber.
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Public property UseRemoteCollation Gets or sets the Boolean property value that specifies whether to use the collation that is associated with the data from the linked server.
Top

  Name Description
Explicit interface implemetation Private property ISfcSupportsDesignMode.IsDesignMode Gets or sets the Boolean property value that specifies whether the schema used by the linked server data is validated when the local instance of SQL Server is idle or not.
Top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft