LinkedServer Members

아티클
12/15/2008

A LinkedServer object represents a database system other than Microsoft SQL Server and is linked to the current instance of SQL Server using an OLE DB driver.

The following tables list the members exposed by the LinkedServer type.

Public Constructors

	이름	Description
	LinkedServer	Overloaded. Initializes a new instance of the LinkedServer object.

위쪽

Protected Fields

	이름	Description
	m_ExtendedProperties	(inherited from SqlSmoObject )

위쪽

Public Properties

(see also Protected Properties )

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

위쪽

Protected Properties

	이름	Description
	ExecuteForScalar	Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (inherited from SqlSmoObject)
	ObjectInSpace	Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly. (inherited from SqlSmoObject)
	PresetProperties	Gets or sets the preset properties of the referenced object. (inherited from SqlSmoObject)
	ScalarResult	Gets the scalar result for the referenced object. (inherited from SqlSmoObject)

위쪽

Public Methods

(see also Protected Methods )

	이름	Description
	Alter	Updates any LinkedServer object property changes on the instance of Microsoft SQL Server.
	Create	Creates a linked server on the instance of Microsoft SQL Server as defined by the LinkedServer object.
	Drop	Overloaded. Removes the reference to the linked server from the instance of Microsoft SQL Server.
	EnumColumns	Overloaded. Enumerates a list of columns that can be accessed on the linked server.
	EnumTables	Overloaded. Enumerates a list of tables that are available on the linked server.
	Equals	Overloaded. (inherited from Object )
	GetHashCode	(inherited from Object )
	GetType	(inherited from Object )
	Initialize	Overloaded. Initializes the object and forces the properties be loaded. (inherited from SqlSmoObject)
	ReferenceEquals	(inherited from Object )
	Refresh	Refreshes the object and retrieves properties when the object is next accessed. (inherited from SqlSmoObject)
	Script	Overloaded. Generates a Transact-SQL script that can be used to re-create the linked server registration.
	ToString	Returns a String that represents the referenced object. (inherited from SqlSmoObject)

위쪽

Protected Methods

	이름	Description
	AlterImpl	(inherited from SqlSmoObject )
	AlterImplFinish	(inherited from SqlSmoObject )
	AlterImplInit	(inherited from SqlSmoObject )
	AlterImplWorker	(inherited from SqlSmoObject )
	BindDefaultImpl	(inherited from SqlSmoObject )
	BindRuleImpl	(inherited from SqlSmoObject )
	CheckCollation	(inherited from SqlSmoObject )
	CheckObjectState	Overloaded. Validates the state of the referenced object. (inherited from SqlSmoObject)
	CheckObjectStateImpl	(inherited from SqlSmoObject )
	CheckVersion80	Checks the validity of the object on Microsoft SQL Server 2000. (inherited from SqlSmoObject)
	CheckVersion80SP3	Checks the validity of the object on Microsoft SQL Server 2000 SP3. (inherited from SqlSmoObject)
	CheckVersion90	Check the validity of the object on Microsoft SQL Server 2005. (inherited from SqlSmoObject)
	CheckVersionBelow90	(inherited from SqlSmoObject )
	CleanObject	(inherited from SqlSmoObject )
	CreateImpl	(inherited from SqlSmoObject )
	CreateImplFinish	(inherited from SqlSmoObject )
	CreateImplInit	(inherited from SqlSmoObject )
	DropImpl	(inherited from SqlSmoObject )
	DropImplWorker	(inherited from SqlSmoObject )
	Finalize	(inherited from Object )
	FormatSqlVariant	(inherited from SqlSmoObject )
	GenerateDataSpaceScript	(inherited from SqlSmoObject )
	GetBindDefaultScript	(inherited from SqlSmoObject )
	GetBindRuleScript	(inherited from SqlSmoObject )
	GetBoolParameter	Overloaded. (inherited from SqlSmoObject )
	GetDateTimeParameter	(inherited from SqlSmoObject )
	GetDateTimeParameterAsInt	(inherited from SqlSmoObject )
	GetDBName	Gets the database name associated with the object. (inherited from SqlSmoObject)
	GetEnumParameter	(inherited from SqlSmoObject )
	GetFragOptionString	(inherited from SqlSmoObject )
	GetGuidParameter	(inherited from SqlSmoObject )
	GetParameter	Overloaded. (inherited from SqlSmoObject )
	GetPropValue	(inherited from SqlSmoObject )
	GetPropValueOptional	(inherited from SqlSmoObject )
	GetPropValueOptionalAllowNull	(inherited from SqlSmoObject )
	GetRealValue	(inherited from SqlSmoObject )
	GetScriptingOptionsForCreate	(inherited from SqlSmoObject )
	GetServerName	Gets the name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject)
	GetSqlServerVersionName	Gets the version name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject)
	GetStringParameter	Overloaded. (inherited from SqlSmoObject )
	GetTimeSpanParameterAsInt	(inherited from SqlSmoObject )
	GetUrnRecursive	Overloaded. (inherited from SqlSmoObject )
	ImplInitialize	(inherited from SqlSmoObject )
	IsCollectionDirty	(inherited from SqlSmoObject )
	IsObjectDirty	Verifies whether the object properties have been modified and the changes have not yet been persisted on the instance of Microsoft SQL Server. (inherited from SqlSmoObject)
	IsObjectInitialized	Verifies whether the object has been initialized. (inherited from SqlSmoObject)
	IsObjectInSpace	Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server. (inherited from SqlSmoObject)
	IsVersion80SP3	(inherited from SqlSmoObject )
	MarkDropped	(inherited from SqlSmoObject )
	MarkForDropImpl	(inherited from SqlSmoObject )
	MemberwiseClone	(inherited from Object )
	PostAlter	(inherited from SqlSmoObject )
	PostCreate	(inherited from SqlSmoObject )
	PostDrop	(inherited from SqlSmoObject )
	RenameImpl	(inherited from NamedSmoObject )
	RenameImplWorker	(inherited from NamedSmoObject )
	ScriptAlter	(inherited from SqlSmoObject )
	ScriptChangeOwner	(inherited from NamedSmoObject )
	ScriptCreate	(inherited from SqlSmoObject )
	ScriptDdl	(inherited from SqlSmoObject )
	ScriptDrop	(inherited from SqlSmoObject )
	ScriptImpl	Overloaded. (inherited from SqlSmoObject )
	ScriptImplWorker	(inherited from SqlSmoObject )
	ScriptRename	(inherited from NamedSmoObject )
	SetParentImpl	(inherited from SqlSmoObject )
	Trace	(inherited from SqlSmoObject )
	UnbindDefaultImpl	(inherited from SqlSmoObject )
	UnbindRuleImpl	(inherited from SqlSmoObject )
	UpdateCollectionState2	(inherited from SqlSmoObject )

위쪽

참고 항목

참조

LinkedServer Class
Microsoft.SqlServer.Management.Smo Namespace

다음을 통해 공유