Server Methods

 

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubmethodAlter()

Updates any Server object property changes on the instance of SQL Server. 

System_CAPS_pubmethodAlter(Boolean)

Updates any Server object property changes on the instance of SQL Server with the option to override value checking.

System_CAPS_pubmethodAttachDatabase(String, StringCollection)

Attaches an existing database that is made up of one or more files to the instance of SQL Server with the specified name and using the specified data files. 

System_CAPS_pubmethodAttachDatabase(String, StringCollection, AttachOptions)

Attaches an existing database that is made up of one or more files to the instance of SQL Server that has the specified name and using the specified data files and attachment options. 

System_CAPS_pubmethodAttachDatabase(String, StringCollection, String)

Attaches an existing database that is made up of one or more files to the instance of SQL Server with the specified name and using the specified data files. 

System_CAPS_pubmethodAttachDatabase(String, StringCollection, String, AttachOptions)

Attaches an existing database that is made up of one or more files to the instance of SQL Server by using the specified name, data files, and attachment options. 

System_CAPS_pubmethodCompareUrn(Urn, Urn)

Compares two URNS.

System_CAPS_pubmethodDeleteBackupHistory(DateTime)

Deletes the backup history for this instance of SQL Server up until the specified date and time.

System_CAPS_pubmethodDeleteBackupHistory(Int32)

Deletes the backup history for the specified media set.

System_CAPS_pubmethodDeleteBackupHistory(String)

Deletes the backup history for the specified database.

System_CAPS_pubmethodDeny(ServerPermissionSet, String)

Denies the specified set of permissions for the specified grantee on the instance of SQL Server.

System_CAPS_pubmethodDeny(ServerPermissionSet, String, Boolean)

Denies the specified set of permissions for the specified grantee and other users that the grantee granted the specified set of permissions on the instance of SQL Server.

System_CAPS_pubmethodDeny(ServerPermissionSet, String[])

Denies the specified set of permissions for the specified grantees on the instance of SQL Server.

System_CAPS_pubmethodDeny(ServerPermissionSet, String[], Boolean)

Denies the specified set of permissions for the specified grantees and other users that the grantee granted the specified set of permissions on the instance of SQL Server.

System_CAPS_pubmethodDetachDatabase(String, Boolean)

Detaches the specified database from the instance of SQL Server with the option to update statistics before the database is detached.

System_CAPS_pubmethodDetachDatabase(String, Boolean, Boolean)

Detaches the specified database from the instance of SQL Server with the option to update statistics before the database is detached.

System_CAPS_pubmethodDetachedDatabaseInfo(String)

Returns information about a detached database file.

System_CAPS_pubmethodDiscover()

Discovers a list of type Object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodEnumActiveCurrentSessionTraceFlags()

Gets active session flags as a DataTable.

System_CAPS_pubmethodEnumActiveGlobalTraceFlags()

Gets a DataTable that contains active global trace flags.

System_CAPS_pubmethodEnumAvailableMedia()

Enumerates a list of media that is visible to the instance of SQL Server on the local area network.

System_CAPS_pubmethodEnumAvailableMedia(MediaTypes)

Enumerates a list of media that is visible to the instance of SQL Server on the local area network and limited to the type of media specified.

System_CAPS_pubmethodEnumClusterMembersState()

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

System_CAPS_pubmethodEnumClusterSubnets()

Enumerates a list of cluster subnets.

System_CAPS_pubmethodEnumCollations()

Enumerates a list of collations supported by the instance of SQL Server.

System_CAPS_pubmethodEnumDatabaseMirrorWitnessRoles()

Enumerates a list of database mirror witness roles.

System_CAPS_pubmethodEnumDatabaseMirrorWitnessRoles(String)

Enumerates a list of mirror witness roles for the specified database.

System_CAPS_pubmethodEnumDetachedDatabaseFiles(String)

Enumerates a list of detached database files.

System_CAPS_pubmethodEnumDetachedLogFiles(String)

Enumerates a list of detached log files.

System_CAPS_pubmethodEnumDirectories(String)

Enumerates a list of directories relative to the specified path.

System_CAPS_pubmethodEnumErrorLogs()

Enumerates a list of SQL Server error log files.

System_CAPS_pubmethodEnumLocks()

Enumerates a list of current locks held on the instance of SQL Server.

System_CAPS_pubmethodEnumLocks(Int32)

Enumerates a list of current locks held by the specified process on the instance of SQL Server.

System_CAPS_pubmethodEnumMembers(RoleTypes)

Enumerates a list of members of server roles and database roles on the instance of SQL Server.

System_CAPS_pubmethodEnumObjectPermissions()

Enumerates a list of object permissions for the instance of SQL Server.

System_CAPS_pubmethodEnumObjectPermissions(ObjectPermissionSet)

Enumerates a list of object permissions for a specified permission on the instance of SQL Server.

System_CAPS_pubmethodEnumObjectPermissions(String)

Enumerates a list of object permissions for a specified grantee on the application instance of SQL Server.

System_CAPS_pubmethodEnumObjectPermissions(String, ObjectPermissionSet)

Enumerates a list of object permissions for a specified grantee and a specified permission on the instance of SQL Server.

System_CAPS_pubmethodEnumPerformanceCounters()

Enumerates a list of performance counters that are supported by the instance of SQL Server.

System_CAPS_pubmethodEnumPerformanceCounters(String)

Enumerates a list of performance counters that are supported by the instance of SQL Server for a specified object.

System_CAPS_pubmethodEnumPerformanceCounters(String, String)

Enumerates a list of performance counters that are supported by the instance of SQL Server for a specified object and specified counter.

System_CAPS_pubmethodEnumPerformanceCounters(String, String, String)

Enumerates a list of performance counters that are supported by the instance of SQL Server for a specified object, for a specified counter, and on the specified instance of SQL Server.

System_CAPS_pubmethodEnumProcesses()

Enumerates a list of processes running on the instance of SQL Server.

System_CAPS_pubmethodEnumProcesses(Boolean)

Enumerates a list of processes running on the instance of SQL Server with the option to exclude system processes.

System_CAPS_pubmethodEnumProcesses(Int32)

Enumerates a list of information about the specified process.

System_CAPS_pubmethodEnumProcesses(String)

Enumerates a list of processes running on the instance of SQL Server that are associated with the specified login.

System_CAPS_pubmethodEnumServerAttributes()

Enumerates a list of server attributes for the instance of SQL Server.

System_CAPS_pubmethodEnumServerPermissions()

Enumerates a list of server permissions for the instance of SQL Server.

System_CAPS_pubmethodEnumServerPermissions(ServerPermissionSet)

Enumerates a list of server permissions for a specified permission on the instance of SQL Server.

System_CAPS_pubmethodEnumServerPermissions(String)

Enumerates a list of server permissions for a specified grantee on the instance of SQL Server.

System_CAPS_pubmethodEnumServerPermissions(String, ServerPermissionSet)

Enumerates a list of server permissions for a specified grantee and a specified permission on the instance of SQL Server.

System_CAPS_pubmethodEnumStartupProcedures()

Enumerates a list of startup procedures.

System_CAPS_pubmethodEnumWindowsDomainGroups()

Enumerates a list of Microsoft Windows group accounts defined on a domain.

System_CAPS_pubmethodEnumWindowsDomainGroups(String)

Enumerates a list of Microsoft Windows group accounts defined for the specified domain.

System_CAPS_pubmethodEnumWindowsGroupInfo()

Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server.

System_CAPS_pubmethodEnumWindowsGroupInfo(String)

Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server.

System_CAPS_pubmethodEnumWindowsGroupInfo(String, Boolean)

Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server and with the option to list the individual members.

System_CAPS_pubmethodEnumWindowsUserInfo()

Enumerates a list of information about all Microsoft Windows users that have explicitly granted access to SQL Server.

System_CAPS_pubmethodEnumWindowsUserInfo(String)

Enumerates a list of information about all Microsoft Windows users that have explicitly granted access to the instance of SQL Server.

System_CAPS_pubmethodEnumWindowsUserInfo(String, Boolean)

Enumerates a list of information about all Microsoft Windows users that have explicitly granted access to the instance of SQL Server and with the option to list all the permissions paths (groups) through which the user has been granted access to the instance of SQL Server.

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_protmethodFormatSqlVariant(Object)

Formats an object as T: Microsoft.Data.Schema.Sql.DataGenerator.SqlVariant type.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodGetActiveDBConnectionCount(String)

Returns the number of active connections for the specified database.

System_CAPS_protmethodGetContextDB()

Gets the context database that is associated with this object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetDBName()

Gets the database name that is associated with the object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodGetDefaultInitFields(Type)

Returns the property types that are initialized by default when the specified object is initialized.

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetPropertyNames(Type)

Returns the names of the initialized properties for the specified object type.

System_CAPS_protmethodGetPropValue(String)

Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetPropValueOptional(String)

Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetPropValueOptionalAllowNull(String)

Gets a property value of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_protmethodGetServerObject()

Gets the server of the SqlSmoObject object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodGetSmoObject(Urn)

Gets a SqlSmoObject that is specified by a URN.

System_CAPS_pubmethodGetStringComparer(String)

Returns the comparer object corresponding to the collation string passed.

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodGrant(ServerPermissionSet, String)

Grants the specified set of permissions to the specified grantee on the instance of SQL Server.

System_CAPS_pubmethodGrant(ServerPermissionSet, String, Boolean)

Grants access to the specified permission to the grantee and the ability to grant access to other users on the instance of SQL Server.

System_CAPS_pubmethodGrant(ServerPermissionSet, String, Boolean, String)

Grants the specified set of permissions to the grantee and the ability to grant the set of permissions to other users on the instance of SQL Server under an assumed role.

System_CAPS_pubmethodGrant(ServerPermissionSet, String[])

Grants the specified set of permissions to the specified grantees on the instance of SQL Server.

System_CAPS_pubmethodGrant(ServerPermissionSet, String[], Boolean)

Grants access to the specified permission to the grantees and the ability to grant access to other users on the instance of SQL Server.

System_CAPS_pubmethodGrant(ServerPermissionSet, String[], Boolean, String)

Grants the specified set of permissions to the grantees and the ability to grant the set of permissions to other users on the instance of SQL Server under an assumed role.

System_CAPS_pubmethodInitialize()

Initializes the object and forces the properties be loaded.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodInitialize(Boolean)

Initializes the object and forces the properties be loaded.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodIsDetachedPrimaryFile(String)

Verifies whether the specified file is a primary (.mdf) database file.

System_CAPS_protmethodIsObjectInitialized()

Verifies whether the object has been initialized.(Inherited from SqlSmoObject.)

System_CAPS_protmethodIsObjectInSpace()

Verifies whether the object is isolated or connected to the instance of SQL Server.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodIsSupportedProperty(String)

(Inherited from SqlSmoObject.)

System_CAPS_pubmethodIsWindowsGroupMember(String, String)

Verifies whether the specified Microsoft Windows user account is a member of the specified Windows group.

System_CAPS_pubmethodJoinAvailabilityGroup(String)

Indicates a specified object to join the availability group.

System_CAPS_pubmethodKillAllProcesses(String)

Stops the all processes on the specified database.

System_CAPS_pubmethodKillDatabase(String)

Deletes the specified database and drops any active connection.

System_CAPS_pubmethodKillProcess(Int32)

Stops the specified process.

System_CAPS_pubmethodPingSqlServerVersion(String)

Gets the version number of the instance of SQL Server.

System_CAPS_pubmethodPingSqlServerVersion(String, String, String)

Get the version number of the specified instance of SQL Server using the specified login and password to gain access.

System_CAPS_pubmethodReadErrorLog()

Enumerates the SQL Server error log.

System_CAPS_pubmethodReadErrorLog(Int32)

Enumerates the specified SQL Server error log.

System_CAPS_pubmethodRefresh()

Refreshes the objects and properties on the Server object.(Overrides SqlSmoObject.Refresh().)

System_CAPS_pubmethodRevoke(ServerPermissionSet, String)

Revokes a previously granted set of permissions from a list of grantees on the instance of SQL Server.

System_CAPS_pubmethodRevoke(ServerPermissionSet, String, Boolean, Boolean)

Revokes previously granted permissions from a grantee on the instance of SQL Server and any other users to whom the grantee has granted the specified set of permissions. The grantee is also given the ability to revoke the specified set of permissions from other users under an assumed role.

System_CAPS_pubmethodRevoke(ServerPermissionSet, String, Boolean, Boolean, String)

Revokes previously granted permissions from a grantee on the instance of SQL Server and any other users to whom the grantee has granted the specified set of permissions. The grantee is also given the ability to revoke the specified set of permissions from other users under an assumed role.

System_CAPS_pubmethodRevoke(ServerPermissionSet, String[])

Revokes a previously granted set of permissions from a list of grantees on the instance of SQL Server.

System_CAPS_pubmethodRevoke(ServerPermissionSet, String[], Boolean, Boolean)

Revokes previously granted permissions from grantees on the instance of SQL Server and any other users to whom the grantees have granted the specified set of permissions. The grantees are also given the ability to revoke the specified set of permissions from other users under an assumed role.

System_CAPS_pubmethodRevoke(ServerPermissionSet, String[], Boolean, Boolean, String)

Revokes previously granted permissions from grantees on the instance of SQL Server and any other users to whom the grantees have granted the specified set of permissions. The grantees are also given the ability to revoke the specified set of permissions from other users under an assumed role.

System_CAPS_pubmethodScript()

Generates a StringCollection of Transact-SQL statements that can be used to re-create the server.

System_CAPS_pubmethodScript(ScriptingOptions)

Generates a StringCollection of Transact-SQL statements that can be used to re-create the server by using the specified scripting options.

System_CAPS_pubmethodSetDefaultInitFields(Boolean)

Specifies that all properties are fetched when objects are instantiated.

System_CAPS_pubmethodSetDefaultInitFields(Type, Boolean)

Specifies all the properties are fetched when objects of the specified type are instantiated.

System_CAPS_pubmethodSetDefaultInitFields(Type, String[])

Specifies the properties that are fetched when objects of the specified type are instantiated.

System_CAPS_pubmethodSetDefaultInitFields(Type, StringCollection)

Specifies the properties that are fetched when objects of the specified type are instantiated.

System_CAPS_protmethodSetParentImpl(SqlSmoObject)

Sets the parent of the SqlSmoObject to the newParent parameter.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodSetTraceFlag(Int32, Boolean)

Sets a trace flag.

System_CAPS_pubmethodToString()

Returns a String that represents the referenced object.(Inherited from SqlSmoObject.)

System_CAPS_pubmethodValidate(String, Object[])

Validates the state of an object.(Inherited from SmoObjectBase.)

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.Discover()

Discovers any dependencies.

Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.GetDomainRoot()

Returns the root of the domain.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.GetParent()

Gets the parent of this object. Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.GetPropertyType(String)

Gets the type of the specified property.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.GetPropertyValue(String, Type)

Gets the value of the specified property.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.GetUrn()

Gets the Unified Resource Name (URN) of the object.

Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.Resolve(String)

Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.SetObjectState(SfcObjectState)

Sets the object state to the specified SfcObjectState value.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienObject.SetPropertyValue(String, Type, Object)

Sets the property value.(Inherited from SqlSmoObject.)

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienRoot.DesignModeInitialize()

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Ensures that the Server object is in design mode, that it is disconnected from the instance of the Database Engine it represents.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienRoot.SfcHelper_GetDataTable(Object, String, String[], OrderBy[])

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Gets a DataTable object containing the results from a URN.

System_CAPS_pubinterfaceSystem_CAPS_privmethodIAlienRoot.SfcHelper_GetSmoObject(String)

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Gets the Object that represents the object identified by a specified URN.

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

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Gets a T:System.Collections.Generic.List of String values.

System_CAPS_pubinterfaceSystem_CAPS_privmethodISfcDomainLite.GetLogicalVersion()

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Gets an Int32 value that indicates whether changes have been made to the Server object.

System_CAPS_pubinterfaceSystem_CAPS_privmethodISfcHasConnection.GetConnection()

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Gets a connection to an Sfc backing store.

System_CAPS_pubinterfaceSystem_CAPS_privmethodISfcHasConnection.GetConnection(SfcObjectQueryMode)

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Gets a connection to an Sfc backing store that supports the requested query mode.

System_CAPS_pubinterfaceSystem_CAPS_privmethodISfcHasConnection.SetConnection(ISfcConnection)

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Sets a connection to an Sfc backing store.

System_CAPS_pubinterfaceSystem_CAPS_privmethodISfcPropertyProvider.GetPropertySet()

Gets the interface reference to the set of properties of this object.

Do not reference this member directly in your code. It supports the SQL Server infrastructure.(Inherited from SqlSmoObject.)

Return to top
Show: