Microsoft.SqlServer.Management.Common 네임스페이스

The [Microsoft.SqlServer.Management.Common] namespace contains classes that provide connection functionality to the other SQL Server management namespaces.

The Microsoft.SqlServer.Management.Common namespace contains the classes that are used to establish a connection to an instance of SQL Server 데이터베이스 엔진. The most important class in this namespace is the ServerConnection class. The ServerConnection object lets you manage the connection to the instance of the 데이터베이스 엔진. It is referenced by various classes in the other manageability namespaces.

The Microsoft.SqlServer.Management.Common namespace resides in the Microsoft.SqlServer.ConnectionInfo.dll assembly file.

By using the Microsoft.SqlServer.Management.Common namespace, you can do the following:

• Connect to an instance of SQL Server.

• Control the connection settings.

• Run Transact-SQL statements directly.

• Capture the Transact-SQL statements that are generated by the SMO program.

• Manage transactions.

클래스

	클래스	설명
	CapturedSql	The CapturedSql class represents the Transact-SQL commands that are sent to the instance of SQL Server by way of the referenced connection. However, they are then redirected to a buffer instead of running immediately on the instance of SQL Server.
	ChangePasswordFailureException	The ChangePasswordFailureException class is an exception that is raised when an unsuccessful attempt is made to change the password of the login that establishes a connection with the instance of SQL Server by using SQL Server Authentication.
	ConnectionCannotBeChangedException	The ConnectionCannotBeChangedException class is an exception that is raised when an unsuccessful attempt is made to change the connection to the instance of Microsoft SQL Server.
	ConnectionException	The ConnectionException class is an exception that is raised when an error occurs on the connection to the instance of SQL Server.
	ConnectionFailureException	The ConnectionFailureException class is an exception that is raised when an unsuccessful attempt is made to establish a connection with the instance of SQL Server.
	ConnectionInfoBase	The ConnectionInfoBase object is a base class that is used in the construction of the SqlOlapConnectionInfoBase class and it represents information used to connect to an instance of SQL Server.
	ConnectionManager	The ConnectionManager class manages the connection to an instance of SQL Server.
	ConnectionSettings	The ConnectionSettings class represents the settings used by a connection to an instance of a server, such as SQL Server. The ServerConnection class inherits ConnectionSettings class.
	DataTransferEventArgs	The DataTransferEventArgs class represents the arguments used when a data transfer event is raised.
	DataTransferProgressEventArgs	The DataTransferProgressEventArgs class represents the arguments used when a data transfer progress event is raised.
	DisconnectedConnectionException	The DisconnectedConnectionException class is an exception that is raised when a connection is closed.
	ExecutionFailureException	The ExecutionFailureException class is an exception that is raised when an execution failure is encountered on the connection to the server.
	InvalidArgumentException	서버에 대한 참조된 연결에서 잘못된 매개 변수가 메서드에 전달될 때 발생하는 예외입니다.
	InvalidPropertyValueException	The exception that is raised when a property is set to a value that is not valid on the referenced connection to the server.
	NotInTransactionException	The exception that is raised when an error occurs within a transaction on the referenced connection to the server.
	OlapConnectionInfo	This class supports the SMO infrastructure and is not intended to be used directly from your code.
	PropertyNotAvailableException	The exception that is raised when an unavailable property is requested on the connection to the server.
	PropertyNotSetException	The exception that is raised when a process requests a property that has not been set on the connection to the server.
	ServerComparer	Represents the comparer class.
	ServerConnection	The ServerConnection object represents a connection to a server.
	ServerMessageEventArgs	The ServerMessageEventArgs class represents the arguments used when a server message event is raised.
	ServerVersion	ServerVersion 클래스는 서버에 대한 버전 정보를 나타냅니다.
	SqlConnectionInfo	The SqlConnectionInfo object represents information that is required to establish a connection to an instance of SQL Server.
	SqlOlapConnectionInfoBase	The SqlOlapConnectionInfoBase class represents information used to connect to the instance of SQL Server.
	SqlServerManagementException	The SqlServerManagementException class is an exception that is raised when a SQL Server management error is encountered on the connection to the server.
	StatementEventArgs	The StatementEventArgs class represents the arguments used when a statement event is raised.
	TransferException	The TransferException class is an exception that is raised when a SQL Server transfer error is encountered on the connection to the server.

인터페이스

	인터페이스	설명
	IAlterable	Defines a method to alter an object on the referenced connection.
	ICreatable	Defines a method to create an object on the referenced connection.
	IDataTransferProvider	Defines methods and events for data transfers on the referenced connection.
	IDroppable	Defines a method to Drop an object on the referenced connection.
	IMarkForDrop	Defines a method that marks an object to be dropped.
	IRefreshable	Defines a method to refresh an object from the server on the referenced connection.
	IRenamable	Defines the Rename method on the referenced connection.
	IRestrictedAccess	Represents an interface that implements single-user access to the server for the referenced connection.
	ISfcConnection	Defines high-level properties and methods for server connections.
	ITransferMetadataProvider	Defines methods that are required for transferring metadata on the referenced connection.

대리자

	대리자	설명
	DataTransferEventHandler	DataTransferEventHandler 클래스는 데이터 전송 프로세스에서 발생한 이벤트를 처리하는 메서드를 나타냅니다.
	DataTransferProgressEventHandler	데이터 전송 진행률 보고 프로세스에서 발생한 이벤트를 처리하는 메서드를 나타냅니다.
	ServerMessageEventHandler	The ServerMessageEventHandler class represents the method that handles the event raised by a server message.
	StatementEventHandler	The StatementEventHandler class represents the method that handles the event raised by a statement.

열거형

	열거형	설명
	AutoDisconnectMode	Contains values that are used to specify the automatic disconnection options for a connection to an instance of SQL Server.
	ConnectionManager. . :: . .ExecuteTSqlAction	Execute a Transact-SQL action.
	ConnectionType	The ConnectionType enumeration contains values that are used to specify the type of server with which the connection is established.
	DatabaseEngineType	Database engine type of stand-alone instance of SQL Server or SQL Azure Database.
	DataTransferEventType	The DataTransferEventType enumeration contains values that are used to specify the type of data transfer event.
	DataTransferProgressEventType	The DataTransferProgressEventType enumeration contains values that are used to specify the type of data transfer progress event.
	DeferredUseMode	The DeferredUseMode enumeration contains values that specify how that deferred use can be instructed to handle Transact-SQL statements on the server connection.
	ExecutionTypes	The ExecutionTypes enumeration contains values that are used to specify execution options for the Transact-SQL commands sent to the server using the referenced connection.
	FixedServerRoles	The FixedServerRoles enumeration contains values that are used to specify fixed server roles that can be assigned to logons.
	NetworkProtocol	Contains values that are used to specify network protocols used on the network where the referenced connection is established.
	QueryParameterizationMode	QueryParameterizationMode 열거형에는 서버 연결에서 매개 변수가 있는 쿼리의 처리 방법을 지정하는 값이 포함되어 있습니다.
	ServerCaseSensitivity	Contains values that are used to specify whether the server is sensitive to the case (lower or upper) of text.
	ServerType	ServerType 열거형에는 SQL Server 서비스의 다양한 유형을 지정하는 값이 포함되어 있습니다.
	ServerUserProfiles	ServerUserProfiles 열거형에는 서버에서 사용자 프로필을 지정하는 데 사용되는 값이 포함되어 있습니다.
	SqlExecutionModes	The SqlExecutionModes enumeration contains values that are used to specify whether the commands sent to the referenced connection to the server are executed immediately or saved in a buffer.