Server Methods
Public Methods
(see also Protected Methods )
Name | Description | |
---|---|---|
Alter |
Updates any Server object property changes on the instance of Microsoft SQL Server.
|
|
AttachDatabase | Overloaded.
Attaches an existing database that is made up of one or more files to the instance of Microsoft SQL Server.
|
|
CompareUrn |
Compares two Uniform Resource Name (URN) addresses.
|
|
DeleteBackupHistory | Overloaded.
Deletes the backup history for this instance of Microsoft SQL Server up until the specified date and time.
|
|
Deny | Overloaded.
Denies the specified set of permissions for the specified grantees on the instance of Microsoft SQL Server.
|
|
DetachDatabase | Overloaded.
Detaches a database from the instance of Microsoft SQL Server.
|
|
DetachedDatabaseInfo |
Returns information about a detached database file.
|
|
EnumAvailableMedia | Overloaded.
Enumerates a list of media that are visible to the instance of Microsoft SQL Server on the local area network.
|
|
EnumCollations |
Enumerates a list of collations supported by the instance of Microsoft SQL Server.
|
|
EnumDatabaseMirrorWitnessRoles | Overloaded.
Enumerates a list of database mirror witness roles.
|
|
EnumDetachedDatabaseFiles |
Enumerates a list of detached database files.
|
|
EnumDetachedLogFiles |
Enumerates a list of detached log files.
|
|
EnumDirectories |
Enumerates a list of directories relative to the specified path.
|
|
EnumErrorLogs |
Enumerates a list of Microsoft SQL Server error log files.
|
|
EnumLocks | Overloaded.
Enumerates a list of current locks held on the instance of Microsoft SQL Server.
|
|
EnumMembers |
Enumerates a list of members of server roles and database roles on the instance of Microsoft SQL Server.
|
|
EnumObjectPermissions | Overloaded.
Enumerates a list of permissions for objects on the instance of Microsoft SQL Server.
|
|
EnumPerformanceCounters | Overloaded.
Enumerates a list of performance counters that are supported by the instance of Microsoft SQL Server.
|
|
EnumProcesses | Overloaded.
Enumerates a list of processes running on the instance of Microsoft SQL Server.
|
|
EnumServerAttributes |
Enumerates a list of server attributes for the instance of SQL Server.
|
|
EnumServerPermissions | Overloaded.
Enumerates a list of server permissions for the instance of Microsoft SQL Server.
|
|
EnumStartupProcedures |
Enumerates a list of startup procedures.
|
|
EnumWindowsDomainGroups | Overloaded.
Enumerates a list of Microsoft Windows group accounts defined on a domain.
|
|
EnumWindowsGroupInfo | Overloaded.
Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of Microsoft SQL Server.
|
|
EnumWindowsUserInfo | Overloaded.
Enumerates a list of information about all Windows users that have explicitly granted access to Microsoft SQL Server.
|
|
Equals | Overloaded. (inherited from Object ) | |
GetActiveDBConnectionCount |
Returns the number of active connections for the specified database.
|
|
GetDefaultInitFields |
Returns the property types that are initialized by default when the specified object is initialized.
|
|
GetHashCode | (inherited from Object ) | |
GetPropertyNames |
Returns the names of the initialized properties for the specified object type
|
|
GetSmoObject |
Returns the object that is specified by a Universal Resource Name (URN) address.
|
|
GetType | (inherited from Object ) | |
Grant | Overloaded.
Grants the specified set of permissions to the specified grantees on the instance of Microsoft SQL Server.
|
|
Initialize | Overloaded.
Initializes the object and forces the properties be loaded.
(inherited from SqlSmoObject ) |
|
IsDetachedPrimaryFile |
Verifies whether the specified file is a primary (.mdf) database file.
|
|
IsWindowsGroupMember |
Verifies whether the specified Microsoft Windows user account is a member of the specified Windows group.
|
|
KillAllProcesses |
Stops the all processes on the specified database.
|
|
KillDatabase |
Deletes the specified database and drops any active connection.
|
|
KillProcess |
Stops the specified process.
|
|
PingSqlServerVersion | Overloaded.
Gets the version number of the instance of Microsoft SQL Server.
|
|
ReadErrorLog | Overloaded.
Enumerates the Microsoft SQL Server error log.
|
|
ReferenceEquals | (inherited from Object ) | |
Refresh | Overridden.
Refreshes the objects and properties on the Server object.
|
|
Revoke | Overloaded.
Revokes a previously granted set of permissions from a grantee or grantees on the instance of Microsoft SQL Server.
|
|
SetDefaultInitFields | Overloaded.
Specifies whether all the properties are fetched when objects are instantiated.
|
|
ToString |
Returns a String that represents the referenced object.
(inherited from SqlSmoObject ) |
Protected Methods
Name | 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 ) | |
ScriptAlter | (inherited from SqlSmoObject ) | |
ScriptCreate | (inherited from SqlSmoObject ) | |
ScriptDdl | (inherited from SqlSmoObject ) | |
ScriptDrop | (inherited from SqlSmoObject ) | |
ScriptImpl | Overloaded. (inherited from SqlSmoObject ) | |
ScriptImplWorker | (inherited from SqlSmoObject ) | |
SetParentImpl | (inherited from SqlSmoObject ) | |
Trace | (inherited from SqlSmoObject ) | |
UnbindDefaultImpl | (inherited from SqlSmoObject ) | |
UnbindRuleImpl | (inherited from SqlSmoObject ) | |
UpdateCollectionState2 | (inherited from SqlSmoObject ) |
See Also
Reference
Server Class
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
Connecting to an Instance of SQL Server
Disconnecting from an Instance of SQL Server
Managing Servers