Condividi tramite


Server Class

Definition

Instance class encapsulating : Server[@Name='']

[Microsoft.SqlServer.Management.Facets.EvaluationMode(Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[Microsoft.SqlServer.Management.Sdk.Sfc.PhysicalFacet]
[Microsoft.SqlServer.Management.Sdk.Sfc.RootFacet(typeof(Microsoft.SqlServer.Management.Smo.Server))]
public sealed class Server : Microsoft.SqlServer.Management.Smo.SqlSmoObject, Microsoft.SqlServer.Management.Common.IAlterable, Microsoft.SqlServer.Management.Sdk.Sfc.IAlienRoot, Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet, Microsoft.SqlServer.Management.Sdk.Sfc.ISfcDomainLite, Microsoft.SqlServer.Management.Sdk.Sfc.ISfcSupportsDesignMode, Microsoft.SqlServer.Management.Smo.IScriptable, Microsoft.SqlServer.Management.Smo.IServerInformation, Microsoft.SqlServer.Management.Smo.IServerSettings
[<Microsoft.SqlServer.Management.Facets.EvaluationMode(Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<Microsoft.SqlServer.Management.Sdk.Sfc.PhysicalFacet>]
[<Microsoft.SqlServer.Management.Sdk.Sfc.RootFacet(typeof(Microsoft.SqlServer.Management.Smo.Server))>]
type Server = class
    inherit SqlSmoObject
    interface ISfcSupportsDesignMode
    interface IAlterable
    interface IScriptable
    interface IServerSettings
    interface IDmfFacet
    interface IServerInformation
    interface IAlienRoot
    interface ISfcDomainLite
    interface ISfcHasConnection
[<Microsoft.SqlServer.Management.Facets.EvaluationMode(Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<Microsoft.SqlServer.Management.Sdk.Sfc.PhysicalFacet>]
[<Microsoft.SqlServer.Management.Sdk.Sfc.RootFacet(typeof(Microsoft.SqlServer.Management.Smo.Server))>]
type Server = class
    inherit SqlSmoObject
    interface IAlterable
    interface IScriptable
    interface IServerSettings
    interface IDmfFacet
    interface IServerInformation
    interface IAlienRoot
    interface ISfcDomainLite
    interface ISfcHasConnection
    interface ISfcSupportsDesignMode
Public NotInheritable Class Server
Inherits SqlSmoObject
Implements IAlienRoot, IAlterable, IDmfFacet, IScriptable, IServerInformation, IServerSettings, ISfcDomainLite, ISfcSupportsDesignMode
Inheritance
Attributes
Implements

Constructors

Server()
Server(ServerConnection)

Constructs a new Server object that relies on the given ServerConnection for connectivity.

Server(String)

Fields

m_ExtendedProperties (Inherited from SqlSmoObject)
singletonParent

Regular SMO objects access the parent class reference through parentColl (corresponding collection in parent class). Singleton class has no collection in parent.

(Inherited from SqlSmoObject)

Properties

ActiveDirectory
AffinityInfo
AuditLevel
Audits
AvailabilityGroups
BackupDevices
BackupDirectory
BrowserServiceAccount
BrowserStartMode
BuildClrVersion
BuildClrVersionString
BuildNumber
ClusterName
ClusterQuorumState
ClusterQuorumType
Collation
CollationID
ComparisonStyle
ComputerNamePhysicalNetBIOS
Configuration
ConnectionContext

connection context

Credentials
CryptographicProviders
DatabaseEngineEdition

Returns the DatabaseEngineEdition of the SMO object

(Inherited from SqlSmoObject)
DatabaseEngineType

Returns the DatabaseEngineType of the SMO object

(Inherited from SqlSmoObject)
Databases
DefaultAvailabilityGroupClusterType

Default availability group cluster type for the server

DefaultFile
DefaultLog
DefaultTextMode
Edition
Endpoints
EngineEdition
ErrorLogPath
ErrorLogSizeKb
Events
ExecuteForScalar (Inherited from SqlSmoObject)
ExecutionManager
FilestreamLevel
FilestreamShareName
FullTextService
HadrManagerStatus
HardwareGeneration
HostDistribution
HostPlatform
HostRelease
HostServicePackLevel
HostSku
Information
InstallDataDirectory
InstallSharedDirectory
InstanceName
IsAvailabilityReplicaSeedingModeSupported
IsCaseSensitive
IsClustered
IsConfigurationOnlyAvailabilityReplicaSupported
IsCrossPlatformAvailabilityGroupSupported
IsFullTextInstalled
IsHadrEnabled
IsMemberOfWsfcCluster

Checks whether the server is a member of WSFC cluster

IsPolyBaseInstalled
IsReadOnlyListWithLoadBalancingSupported
IsSingleUser
IsTouched

Whether the object has been touched for unconditional scripting of Alter

(Inherited from SqlSmoObject)
IsXTPSupported
JobServer
Language
Languages
LinkedServers
LoginMode
Logins
Mail
MailProfile
MasterDBLogPath
MasterDBPath
MaxPrecision
Name
NamedPipesEnabled
NetName
NumberOfLogFiles
ObjectInSpace (Inherited from SqlSmoObject)
OleDbProviderSettings
OSVersion
ParentCollection

Returns the collection that contains the object. May be null.

(Inherited from SqlSmoObject)
PathSeparator
PerfMonMode
PhysicalMemory
PhysicalMemoryUsageInKB
Platform
Processors
ProcessorUsage
Product
ProductLevel
ProductUpdateLevel
Properties (Inherited from SqlSmoObject)
ProxyAccount
ReservedStorageSizeMB
ResourceGovernor
ResourceLastUpdateDateTime
ResourceVersion
ResourceVersionString
Roles
RootDirectory
ScalarResult (Inherited from SqlSmoObject)
ServerAuditSpecifications
ServerType
ServerVersion

Returns the ServerVersion of the Server that contains the object. If the object is not associated with a connected Server, the highest known server version is returned.

(Inherited from SqlSmoObject)
ServiceAccount
ServiceInstanceId
ServiceMasterKey
ServiceName
ServiceStartMode
ServiceTier
Settings
SmartAdmin
SqlCharSet
SqlCharSetName
SqlDomainGroup
SqlSortOrder
SqlSortOrderName
State

Returns the state of the object

(Inherited from SmoObjectBase)
Status
SupportedAvailabilityGroupClusterTypes

Gets the supported availability group cluster types for the server

SystemDataTypes
SystemMessages
TapeLoadWaitTime
TcpEnabled
Triggers
Urn

Returns the Urn of the object, computed on the fly

(Inherited from SqlSmoObject)
UrnSuffix
UsedStorageSizeMB
UserData (Inherited from SmoObjectBase)
UserDefinedMessages
UserOptions
Version
VersionMajor
VersionMinor
VersionString

Methods

AddDatabaseContext(StringCollection)

method get called from the create script related method (from derived classes like Table, Index etc..)

(Inherited from SqlSmoObject)
Alter()

Alter the metadata for the server, including dependent child objects such as Configuration, Information, and Settings. The Configuration class will not override value checking with this call.

Alter(Boolean)

Alter the metadata for the server, including dependent child objects such as Configuration, Information, and Settings.

AlterImpl() (Inherited from SqlSmoObject)
AlterImplWorker() (Inherited from SqlSmoObject)
AttachDatabase(String, StringCollection, AttachOptions)

Attach Database

AttachDatabase(String, StringCollection, String, AttachOptions)

Attach Database

AttachDatabase(String, StringCollection, String)

Attach Database

AttachDatabase(String, StringCollection)

Attach Database

BindDefaultImpl(String, String, Boolean) (Inherited from SqlSmoObject)
BindRuleImpl(String, String, Boolean) (Inherited from SqlSmoObject)
CheckObjectState() (Inherited from SqlSmoObject)
CheckObjectState(Boolean)

This is a virtual function, so that derived classes can override it if they want to do additional checks on the state of the object

(Inherited from SqlSmoObject)
CheckObjectStateImpl(Boolean)

Checks object state Because it is not recusrive, this function can be called directly and which means derived classes can't supply their own validation

(Inherited from SqlSmoObject)
CleanObject() (Inherited from SqlSmoObject)
CompareUrn(Urn, Urn)

Compares two Urn's, taking into account the collations on the server

CreateImpl() (Inherited from SqlSmoObject)
CreateOrAlterImpl() (Inherited from SqlSmoObject)
DeleteBackupHistory(DateTime)

Deletes the entries in the backup and restore history tables for backup sets older than oldestDate

DeleteBackupHistory(Int32)

Deletes the entries in the backup and restore history tables for backup sets on mediaSetID

DeleteBackupHistory(String)

Deletes the entries in the backup and restore history tables for database

Deny(ServerPermissionSet, String, Boolean)
Deny(ServerPermissionSet, String)
Deny(ServerPermissionSet, String[], Boolean)
Deny(ServerPermissionSet, String[])
DetachDatabase(String, Boolean, Boolean)

Detach a database

DetachDatabase(String, Boolean)

Detach a database

DetachedDatabaseInfo(String)

The DetachedDBInfo method returns information about a detached database.

Discover()

Best Effort Discovery mechanism : This method reflects upon metadata and gets all available objects

(Inherited from SqlSmoObject)
DropImpl(Boolean, Boolean)

For drop calls on the user database in Azure, the connection will be closed as the database is dropped The ExecutionManager will normally attempt to retry such calls by reopening the connection We want to avoid this retry when handleSevereError is true.

(Inherited from SqlSmoObject)
DropImpl(Boolean)

drops the object

(Inherited from SqlSmoObject)
DropImplWorker(Urn, Boolean)

drops the object

(Inherited from SqlSmoObject)
EnumActiveCurrentSessionTraceFlags()

Returns output of DBCC TRACESTATUS()

EnumActiveGlobalTraceFlags()

Enumerate all active global trace flags set for SQL Instance and return them as DataTable

EnumAvailableMedia()

Returns output of xp_availablemedia

EnumAvailableMedia(MediaTypes)

Returns output of xp_availablemedia

EnumClusterMembersState()

Enumerate the current state of the Windows cluster members of which the instance is a part of.

EnumClusterSubnets()

Enumerate the current state of the Windows cluster members of which the instance is a part of.

EnumCollations()
EnumDatabaseMirrorWitnessRoles()

Enumerates the witness roles the server plays in a database mirroring partnership

EnumDatabaseMirrorWitnessRoles(String)
EnumDetachedDatabaseFiles(String)

The ListDetachedDBFiles method lists all database files referenced by a primary database file.

EnumDetachedLogFiles(String)

The ListDetachedLogFiles method lists all log files referenced by primary log file.

EnumDirectories(String)
EnumErrorLogs()
EnumLocks()

Returns a table of active locks

EnumLocks(Int32)

Returns a table of active locks

EnumMembers(RoleTypes)

The ListMembers method returns a NameList object that enumerates the Microsoft� SQL Server� 2000 server or database roles in which the SQLServer object login has membership. For SDS, there is no concept of server roles. Depending on the connection to the databases, we will get information about membership in the database roles. There are two special database roles in master database in SDS, sds_securityadmin and sds_dbcreator, membership of whose can only be got while connected to master database.

EnumObjectPermissions()
EnumObjectPermissions(ObjectPermissionSet)
EnumObjectPermissions(String, ObjectPermissionSet)
EnumObjectPermissions(String)
EnumPerformanceCounters()

Retrieves performance counter data from the server.

EnumPerformanceCounters(String, String, String)

Retrieves performance counter data from the server.

EnumPerformanceCounters(String, String)

Retrieves performance counter data from the server.

EnumPerformanceCounters(String)

Retrieves performance counter data from the server.

EnumProcesses()
EnumProcesses(Boolean)

enumerate processes optionaly excluting the system processes

EnumProcesses(Int32)
EnumProcesses(String)
EnumServerAttributes()

Returns the content of sp_server_info

EnumServerPermissions()
EnumServerPermissions(ServerPermissionSet)
EnumServerPermissions(String, ServerPermissionSet)
EnumServerPermissions(String)
EnumStartupProcedures()
EnumWindowsDomainGroups()
EnumWindowsDomainGroups(String)
EnumWindowsGroupInfo()

Returns output of xp_logininfo filtered to groups

EnumWindowsGroupInfo(String, Boolean)

Returns output of xp_logininfo filtered to groups.

EnumWindowsGroupInfo(String)

Returns output of xp_logininfo filtered to groups

EnumWindowsUserInfo()

Returns output of xp_logininfo filtered to users

EnumWindowsUserInfo(String, Boolean)

Returns output of xp_logininfo filtered to users

EnumWindowsUserInfo(String)

Returns output of xp_logininfo filtered to users

ExecuteNonQuery(StringCollection, Boolean, Boolean)

Executes sql statements

(Inherited from SqlSmoObject)
ExecuteWithModes(SqlExecutionModes, Action)

Executes the given action under the given execution modes.

Resets the original modes after the action completes or fails.

(Inherited from SqlSmoObject)
FileExists(String)

Checks whether the specified file exists

FormatSqlVariant(Object) (Inherited from SqlSmoObject)
GenerateAlterEvent() (Inherited from SqlSmoObject)
GenerateAlterEvent(Urn, Object) (Inherited from SqlSmoObject)
GetActiveDBConnectionCount(String)
GetContextDB() (Inherited from SqlSmoObject)
GetDBName() (Inherited from SqlSmoObject)
GetDefaultInitFields(Type, DatabaseEngineEdition)

returns a clone of the default init fields

GetDefaultInitFields(Type)

returns a clone of the default init fields. This function will be deprecated. Please use the overload function.

GetDisabledProperties(ScriptingPreferences)

Provides an enumerable of properties that are explicitly disabled for specific server types or editions. This is not a list of all properties that don't work for the specified target.

(Inherited from SqlSmoObject)
GetFragOptionString(FragmentationOption) (Inherited from SqlSmoObject)
GetPropertyNames(Type, DatabaseEngineEdition)

Get the Property field supported by given object type

GetPropValue(String)

Retrieve the property value from : - The property bag directly if property is available (dirty or retrieved) - A call to our OnPropertyMissing method otherwise

Will throw an exception if the property value is NULL in either case.

(Inherited from SqlSmoObject)
GetPropValueOptional(String)

Retrieve the property value from : - The property bag if the state is creating or we're in Design Mode (possible NULL value) - A call to our OnPropertyMissing method otherwise (will throw exception if value is NULL)

(Inherited from SqlSmoObject)
GetPropValueOptional<T>(String, T)

Returns the value of the named property. If the object is in the Creating state and the property has not yet been set the defaultValue is returned. If the object exists the defaultValue is ignored and the actual value is returned.

(Inherited from SqlSmoObject)
GetPropValueOptionalAllowNull(String)

Retrieve the property value from : - The property bag if the state is creating or we're in Design Mode (possible NULL) - A call to our OnPropertyMissing method otherwise (possible NULL)

(Inherited from SqlSmoObject)
GetRealValue(Property, Object)

Returns the real value for the property.

(Inherited from SqlSmoObject)
GetServerName() (Inherited from SqlSmoObject)
GetServerObject() (Inherited from SqlSmoObject)
GetSmoObject(Urn)

Returns the object with the corresponding Urn

GetSqlServerVersionName()

Gets the sqlserver public name for the current connection, e.g: will transfer "SQLTOOLS2008-2" to "SQL Server 2008".

(Inherited from SqlSmoObject)
GetStringComparer()

Returns the comparer used by all child object collections to perform comparison of object names. The comparer of a Server is based on the collation of master The comparer of a Database and its children is based on the database collation

(Inherited from SqlSmoObject)
GetStringComparer(String)

Returns the comparer object corresponding to the collation string passed.

GetUrnRecursive(StringBuilder, UrnIdOption)

Computes the Urn for the object, potentially including other fields in the definition besides the key fields.

(Inherited from SqlSmoObject)
GetUrnRecursive(StringBuilder)

Computes the Urn for the object.

(Inherited from SqlSmoObject)
Grant(ServerPermissionSet, String, Boolean, String)
Grant(ServerPermissionSet, String, Boolean)
Grant(ServerPermissionSet, String)
Grant(ServerPermissionSet, String[], Boolean, String)
Grant(ServerPermissionSet, String[], Boolean)
Grant(ServerPermissionSet, String[])
GrantAvailabilityGroupCreateDatabasePrivilege(String)

This method is called on a secondary replica that has joined the availability group to grant availability group create database privilege for automatic seeding to work

ImplInitialize(String[], OrderBy[]) (Inherited from SqlSmoObject)
InitChildCollection(Urn, Boolean)

Initializes the child object collection associated with the given type. For example, the name Column would initialize the Columns collection.

(Inherited from SqlSmoObject)
Initialize() (Inherited from SqlSmoObject)
Initialize(Boolean)

Initializes the object, by reading its properties from the enumerator

(Inherited from SqlSmoObject)
IsDetachedPrimaryFile(String)

The IsDetachedPrimaryFile method specifies whether a file is a detached primary database file.

IsExpressSku()

Returns whether the server containing this object is an Express SKU

(Inherited from SqlSmoObject)
IsObjectDirty() (Inherited from SqlSmoObject)
IsObjectInitialized() (Inherited from SqlSmoObject)
IsObjectInSpace() (Inherited from SqlSmoObject)
IsSupportedProperty(String)

Validate whether the specified property is supported in current server environment

(Inherited from SqlSmoObject)
IsTraceFlagOn(Int32, Boolean)

Checks whether a trace flag is enabled on the server

IsVersion80SP3() (Inherited from SqlSmoObject)
IsVersion90AndAbove() (Inherited from SqlSmoObject)
IsWindowsGroupMember(String, String)

The IsNTGroupMember method exposes an instance of Microsoft� SQL Server� 2000 access rights for Windows NT� 4.0 or Microsoft Windows 2000 user accounts. Cloud for now doesn't support windows logins. And Sql logins can't be member of any windows group. Hence this method is not supported for Cloud.

JoinAvailabilityGroup(String, AvailabilityGroupClusterType)

This method is called on a secondary replica that has been added to an Availability Group from a primary to complete the handshake. Upon successful execution the instance will become a functioning replica in the availability group.

JoinAvailabilityGroup(String)

This method is called on a secondary replica that has been added to an Availability Group from a primary to complete the handshake. Upon successful execution the instance will become a functioning replica in the availability group.

KillAllProcesses(String)

Kills all user processes that are using the given database.

KillDatabase(String)

Drops a database. If users are connected to it their connections will be dropped.

KillProcess(Int32)
MarkDropped() (Inherited from SqlSmoObject)
MarkForDropImpl(Boolean) (Inherited from SqlSmoObject)
ParentDirectoryExists(String)

Checks whether the parent directory of the specified file exists

PingSqlServerVersion(String, String, String)

will connect to the specified serve, retrieve the version string, and disconnect before return to the caller This allows caller to ping the SQLServer version Expensive because we need to make a connection to get the info, call only when necessary

PingSqlServerVersion(String)

will connect to the specified serve, retrieve the version string, and disconnect before return to the caller This allows caller to ping the SQLServer version Expensive because we need to make a connection to get the info, call only when necessary

PostAlter()

this function is meant to be overriden by derived classes, if they have to do supplimentary actions after altering the object

(Inherited from SqlSmoObject)
PostCreate()

this function is meant to be overriden by derived classes, if they have to do supplimentary actions after object creation

(Inherited from SqlSmoObject)
PostDrop()

this function is meant to be overriden by derived classes, if they have to do supplimentary actions after dropping the object

(Inherited from SqlSmoObject)
ReadErrorLog()
ReadErrorLog(Int32)
Refresh()
Revoke(ServerPermissionSet, String, Boolean, Boolean, String)
Revoke(ServerPermissionSet, String, Boolean, Boolean)
Revoke(ServerPermissionSet, String)
Revoke(ServerPermissionSet, String[], Boolean, Boolean, String)
Revoke(ServerPermissionSet, String[], Boolean, Boolean)
Revoke(ServerPermissionSet, String[])
RevokeAvailabilityGroupCreateDatabasePrivilege(String)

Revoke the create database privilege of the specified availability group

Script()
Script(ScriptingOptions)
ScriptImpl() (Inherited from SqlSmoObject)
ScriptImpl(ScriptingOptions)

Returns a StringCollection object with the script for the object. This method throws an error if ScriptData is true

(Inherited from SqlSmoObject)
SetAccessToken(IRenewableToken)

Set the accessToken for connection.

(Inherited from SqlSmoObject)
SetDefaultInitFields(Boolean)

Sets a value indicating whether objects in collections should be initialized with all properties and clears any prior settings from other overrides of this method. Specific properties to fetch for a given type can be chosen for initialization by using another override of this method.

SetDefaultInitFields(Type, Boolean, DatabaseEngineEdition)

Set the default fields of the given object type

SetDefaultInitFields(Type, Boolean)

Set the default fields of the given object type. This function will be deprecated. Please use the overload function.

SetDefaultInitFields(Type, DatabaseEngineEdition, String[])

Set the default fields of the given object type

SetDefaultInitFields(Type, String[])

Set the default fields of the given object type. This function will be deprecated. Please use the overload function.

SetDefaultInitFields(Type, StringCollection, DatabaseEngineEdition)

Set the default fields of the given object type

SetDefaultInitFields(Type, StringCollection)

Set the default for the fields of the given object type. This function will be deprecated. Please use the overload function.

SetParentImpl(SqlSmoObject) (Inherited from SqlSmoObject)
SetState(SqlSmoState)

Sets the object state (Existing, Dropped etc.) Applications should avoid using this method.

(Inherited from SmoObjectBase)
SetTraceFlag(Int32, Boolean)

Sets a session trace flag

ThrowIfAboveVersion100(String)

Throws an exception if the ServerVersion major version for this object is above 10.0 (SQL 2008)

(Inherited from SqlSmoObject)
ThrowIfAboveVersion80(String)

Throws an exception if the ServerVersion major version for this object is above 8.0 (SQL 2000)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion100(String)

Throws an exception if the ServerVersion major version for this object is below 10.0 (SQL 2008)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion110(String)

Throws an UnsupportedVersionException if either the source or destination server is below 11.0 (SQL 2012)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion110Prop(String)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 11.0 (SQL 2012)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion120(String)

Throws an exception if the ServerVersion major version for this object is below 12.0 (SQL 2014)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion120Prop(String)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 12.0 (SQL 2014)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion130(String)

Throws an exception if the ServerVersion major version for this object is below 13.0 (SQL 2016)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion130Prop(String)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 13.0 (SQL 2016)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion140(String)

Throws an exception if the ServerVersion major version for this object is below 14.0 (SQL 2017)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion140Prop(String)

Throws an exception with text saying the specified property is not supported if the ServerVersion major version for this object is below 14.0 (SQL 2017)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion80(String)

Throws an exception if the ServerVersion major version for this object is below 8.0 (SQL 2000)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion80SP3()

Throws an exception if the ServerVersion for this object is below 8.760 (8.0 SP3)

(Inherited from SqlSmoObject)
ThrowIfBelowVersion90(String)

Throws an exception if the ServerVersion major version for this object is below 9.0 (SQL 2005)

(Inherited from SqlSmoObject)
ToString() (Inherited from SqlSmoObject)
Touch()

Mark the object "touched" for unconditional scripting of Alter.

(Inherited from SqlSmoObject)
TouchImpl()

Virtual method to allow derived classes to do additional work when touched.

(Inherited from SqlSmoObject)
UnbindDefaultImpl(Boolean) (Inherited from SqlSmoObject)
UnbindRuleImpl(Boolean) (Inherited from SqlSmoObject)
Validate(String, Object[]) (Inherited from SmoObjectBase)

Events

PropertyChanged (Inherited from SqlSmoObject)
PropertyMetadataChanged (Inherited from SqlSmoObject)

Explicit Interface Implementations

IAlienObject.Discover() (Inherited from SqlSmoObject)
IAlienObject.GetDomainRoot() (Inherited from SqlSmoObject)
IAlienObject.GetParent() (Inherited from SqlSmoObject)
IAlienObject.GetPropertyType(String)

Discovers type of property.

(Inherited from SqlSmoObject)
IAlienObject.GetPropertyValue(String, Type)

Retrieves value for a given property. Throws if property is not found.

(Inherited from SqlSmoObject)
IAlienObject.GetUrn() (Inherited from SqlSmoObject)
IAlienObject.Resolve(String) (Inherited from SqlSmoObject)
IAlienObject.SetObjectState(SfcObjectState)

Sets state of this object based on provided SfcObjectState.

(Inherited from SqlSmoObject)
IAlienObject.SetPropertyValue(String, Type, Object)

Sets the value of given property, if it is writable. If property is not in property bag, reflection is used. Throws exception if the property is not found.

(Inherited from SqlSmoObject)
IAlienRoot.DesignModeInitialize()
IAlienRoot.SfcHelper_GetDataTable(Object, String, String[], OrderBy[])

Helper for SFC. Ask Enumerator for a DataTable of results given a Urn.

IAlienRoot.SfcHelper_GetSmoObject(String)

Returns the object with the corresponding Urn in string form

IAlienRoot.SfcHelper_GetSmoObjectQuery(String, String[], OrderBy[])

Helper for SFC. Query and iterator/enumerator interfaces should be the level we abstract at, but for now we make sure caching via InitChildLevel is done while we still give back the list of Urns.

ISfcDomainLite.DomainInstanceName

Returns the instance name of this domain

ISfcDomainLite.DomainName

Returns the SMO domain name

ISfcDomainLite.GetLogicalVersion()

Returns logical version of SMO object model schema

ISfcHasConnection.ConnectionContext
ISfcHasConnection.GetConnection()
ISfcHasConnection.GetConnection(SfcObjectQueryMode)
ISfcHasConnection.SetConnection(ISfcConnection)
ISfcPropertyProvider.GetPropertySet() (Inherited from SqlSmoObject)
ISfcSupportsDesignMode.IsDesignMode

This object extend ISfcSupportsDesignMode.

Extension Methods

GetAssessmentItems(Server, String[])

Finds all available checks for given server.

GetAssessmentItems(SqlSmoObject, String[])

Finds all available checks for given smoObject.

GetAssessmentResults(Server, IEnumerable<ICheck>)

Synchronously runs assessment for given server and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

GetAssessmentResults(Server, String[])

Synchronously runs assessment for given server and gives a IEnumerable<T> describing discovered issues.

GetAssessmentResults(SqlSmoObject, IEnumerable<ICheck>)

Synchronously runs assessment for given smoObject and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

GetAssessmentResults(SqlSmoObject, String[])

Synchronously runs assessment for given smoObject and gives a IEnumerable<T> describing discovered issues.

GetAssessmentResultsList(Server, IEnumerable<ICheck>)

Synchronously runs assessment for given server and gives a IEnumerable<T> describing discovered issues. This method performs only given checks from checks.

GetAssessmentResultsList(Server, String[])

Asynchronously runs assessment for given server and gives a List<T> describing discovered issues.

GetAssessmentResultsList(SqlSmoObject, IEnumerable<ICheck>)

Asynchronously runs assessment for given smoObject and gives a List<T> describing discovered issues. This method performs only given checks from checks.

GetAssessmentResultsList(SqlSmoObject, String[])

Asynchronously runs assessment for given smoObject and gives a List<T> describing discovered issues.

IsSupportedObject<T>(SqlSmoObject, ScriptingPreferences)

Checks if the specified type is supported by the ServerVersion and DatabaseEngineType of the root server for this object. If ScriptingPreferences are non-null will also check if specified type is supported by the ServerVersion and DatabaseEngineType of the target server.

Applies to