Export (0) Print
Expand All

LinkedServer Properties

The LinkedServer type exposes the following members.

  NameDescription
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.
Protected property ExecuteForScalar Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Inherited from SqlSmoObject.)
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.
Protected property IsTouched Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Inherited from SqlSmoObject.)
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 the name of the object. (Inherited from NamedSmoObject.)
Protected property ObjectInSpace Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (Inherited from SqlSmoObject.)
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.
Protected property ScalarResult Gets the scalar result for the referenced object. (Inherited from SqlSmoObject.)
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

Community Additions

ADD
Show:
© 2014 Microsoft