Export (0) Print
Expand All

Database Methods

(see also Protected Methods )
  Name Description
ms219496.pubmethod(en-US,SQL.90).gif Alter Overloaded.
Updates any Database object property changes on an instance of Microsoft SQL Server.
ms219496.pubmethod(en-US,SQL.90).gif ChangeMirroringState
Changes the mirroring configuration as specified by the options.
ms219496.pubmethod(en-US,SQL.90).gif CheckAllocations
Scans all pages of the referenced database and tests pages to guarantee integrity.
ms219496.pubmethod(en-US,SQL.90).gif CheckAllocationsDataOnly
Scans all pages of the referenced database and tests only the data to guarantee integrity.
ms219496.pubmethod(en-US,SQL.90).gif CheckCatalog
Tests the integrity of the database catalog.
ms219496.pubmethod(en-US,SQL.90).gif CheckIdentityValues
Verifies the integrity of all identity columns in tables in the database.
ms219496.pubmethod(en-US,SQL.90).gif Checkpoint
Issues a checkpoint.
ms219496.pubmethod(en-US,SQL.90).gif CheckTables
Tests the integrity of database pages for all tables and indexes defined on the tables of the database.
ms219496.pubmethod(en-US,SQL.90).gif CheckTablesDataOnly
Tests integrity of pages that store data for all tables and indexes defined on the tables of the referenced database.
ms219496.pubmethod(en-US,SQL.90).gif Create Overloaded.
Creates a database on the instance of Microsoft SQL Server as defined by the Database object.
ms219496.pubmethod(en-US,SQL.90).gif Deny Overloaded.
Denies the specified set of permissions for the specified grantees on the database.
ms219496.pubmethod(en-US,SQL.90).gif Drop
Drops the database.
ms219496.pubmethod(en-US,SQL.90).gif DropBackupHistory
Drops the backup history for the database.
ms219496.pubmethod(en-US,SQL.90).gif EnumCandidateKeys
Enumerates a list of all candidate primary keys in the database, which may be referenced by a foreign key.
ms219496.pubmethod(en-US,SQL.90).gif EnumDatabasePermissions Overloaded.
Enumerates a list of all database permissions in the database.
ms219496.pubmethod(en-US,SQL.90).gif EnumLocks Overloaded.
Enumerates a list of current locks on the database.
ms219496.pubmethod(en-US,SQL.90).gif EnumLoginMappings
Enumerates a list of Microsoft SQL Server logins for all the users in the database.
ms219496.pubmethod(en-US,SQL.90).gif EnumMatchingSPs Overloaded.
Enumerates a list of stored procedures that contain the specified string in the definition.
ms219496.pubmethod(en-US,SQL.90).gif EnumObjectPermissions Overloaded.
Enumerates a list of permissions for objects in the database.
ms219496.pubmethod(en-US,SQL.90).gif EnumObjects Overloaded.
Enumerates a list of objects in the database.
ms219496.pubmethod(en-US,SQL.90).gif EnumTransactions Overloaded.
Enumerates a list of open transactions on the database.
ms219496.pubmethod(en-US,SQL.90).gif EnumWindowsGroups Overloaded.
Enumerates a list of Microsoft Windows groups.
ms219496.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219496.pubmethod(en-US,SQL.90).gif ExecuteNonQuery Overloaded.
Executes a collection of batches in the context of the database where there are no results returned.
ms219496.pubmethod(en-US,SQL.90).gif ExecuteWithResults Overloaded.
Executes a collection of batches in the context of the database where there are results returned.
ms219496.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms219496.pubmethod(en-US,SQL.90).gif GetTransactionCount Overloaded.
Gets the number of open transactions on the database.
ms219496.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms219496.pubmethod(en-US,SQL.90).gif Grant Overloaded.
Grants the specified set of permissions to the specified grantees on the database.
ms219496.pubmethod(en-US,SQL.90).gif Initialize  Overloaded.
Initializes the object and forces the properties be loaded.
(inherited from SqlSmoObject )
ms219496.pubmethod(en-US,SQL.90).gif IsMember
Determines whether the specified group or role belongs to the database.
ms219496.pubmethod(en-US,SQL.90).gif PrefetchObjects Overloaded.
Prefetches database objects.
ms219496.pubmethod(en-US,SQL.90).gif RecalculateSpaceUsage
Recalculates space usage.
ms219496.pubmethod(en-US,SQL.90).gif ms219496.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219496.pubmethod(en-US,SQL.90).gif Refresh Overridden.
Updates the Database object.
ms219496.pubmethod(en-US,SQL.90).gif RemoveFullTextCatalogs
Removes full-text catalogs from the database.
ms219496.pubmethod(en-US,SQL.90).gif Rename
Renames the database.
ms219496.pubmethod(en-US,SQL.90).gif Revoke Overloaded.
Revokes a previously granted set of permissions from a grantee or grantees on the database.
ms219496.pubmethod(en-US,SQL.90).gif Script Overloaded.
Generates a Transact-SQL script that can be used to re-create the database.
ms219496.pubmethod(en-US,SQL.90).gif SetDefaultFileGroup
Sets the default file group for the database.
ms219496.pubmethod(en-US,SQL.90).gif SetDefaultFullTextCatalog
Sets the default full-text catalog for the database.
ms219496.pubmethod(en-US,SQL.90).gif SetOffline
Sets the database offline.
ms219496.pubmethod(en-US,SQL.90).gif SetOnline
Sets the database online.
ms219496.pubmethod(en-US,SQL.90).gif SetOwner Overloaded.
Sets the database owner.
ms219496.pubmethod(en-US,SQL.90).gif Shrink
Shrinks the database.
ms219496.pubmethod(en-US,SQL.90).gif ToString 
Returns a String that represents the referenced object.
(inherited from SqlSmoObject )
ms219496.pubmethod(en-US,SQL.90).gif TruncateLog
Truncates the database log.
ms219496.pubmethod(en-US,SQL.90).gif UpdateIndexStatistics
Updates index statistics.

  Name Description
ms219496.protmethod(en-US,SQL.90).gif AlterImpl  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif AlterImplFinish  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif AlterImplInit  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif AlterImplWorker  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif AppendCommaText  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif AppendWithCommaText  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif AppendWithOption  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif BindDefaultImpl  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif BindRuleImpl  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif CheckCollation  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif CheckObjectState  Overloaded.
Validates the state of the referenced object.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif CheckObjectStateImpl  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif CheckTextCorectness  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif CheckTextModeSupport  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif CheckVersion80 
Checks the validity of the object on Microsoft SQL Server 2000.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif CheckVersion80SP3 
Checks the validity of the object on Microsoft SQL Server 2000 SP3.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif CheckVersion90 
Check the validity of the object on Microsoft SQL Server 2005.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif CheckVersionBelow90  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif CleanObject 
Cleans the referenced object.
(inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif CreateImpl  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif CreateImplFinish  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif CreateImplInit  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif DropImpl  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif DropImplWorker  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms219496.protmethod(en-US,SQL.90).gif ForceTextModeOnTextBody 
Enforces text mode on the text body.
(inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif FormatSqlVariant  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GenerateDataSpaceScript  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetBindDefaultScript  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetBindRuleScript  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetBoolParameter  Overloaded. (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetBraketNameForText  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif GetDateTimeParameter  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetDateTimeParameterAsInt  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetDBName 
Gets the database name associated with the object.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetEnumParameter  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetFragOptionString  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetGuidParameter  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetIsTextDirty 
Determines whether the text value is consistent with stored value.
(inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif GetParameter  Overloaded. (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetPropValue  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetPropValueOptional  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetPropValueOptionalAllowNull  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetRealValue  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetScriptIncludeExists  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif GetScriptingOptionsForCreate  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetServerName 
Gets the name of the instance of Microsoft SQL Server with which the object is associated.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetSqlServerVersionName 
Gets the version name of the instance of Microsoft SQL Server with which the object is associated.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetStringParameter  Overloaded. (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetTextBody  Overloaded.
Returns the text body.
(inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif GetTextForScript  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif GetTextHeader  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif GetTextMode 
Determines whether the script name is using text mode.
(inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif GetTextProperty  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif GetTimeSpanParameterAsInt  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif GetUrnRecursive  Overloaded. (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif ImplInitialize  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif ms219496.static(en-US,SQL.90).gif IsCollectionDirty  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif IsObjectDirty 
Determines whether the referenced object is consistent with the stored object.
(inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif IsObjectInitialized 
Verifies whether the object has been initialized.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif IsObjectInSpace 
Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif IsVersion80SP3  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif MarkDropped 
This method supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif MarkForDropImpl  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms219496.protmethod(en-US,SQL.90).gif PostAlter  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif PostCreate 
This method supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif PostDrop  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif RenameImpl  (inherited from NamedSmoObject )
ms219496.protmethod(en-US,SQL.90).gif RenameImplWorker  (inherited from NamedSmoObject )
ms219496.protmethod(en-US,SQL.90).gif ScriptAlter 
This method supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code.
(inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif ScriptAnsiQI  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif ScriptChangeOwner  (inherited from NamedSmoObject )
ms219496.protmethod(en-US,SQL.90).gif ScriptCreate  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif ScriptDdl  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif ScriptDrop  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif ScriptImpl  Overloaded. (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif ScriptImplWorker  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif ScriptInformativeHeaders  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif ScriptRename  (inherited from NamedSmoObject )
ms219496.protmethod(en-US,SQL.90).gif SetCollectionTextMode  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif SetParentImpl  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif SetTextBody  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif SetTextHeader  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif SetTextMode  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif SwitchTextMode  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif ThrowIfTextIsDirtyForAlter  (inherited from ScriptNameObjectBase )
ms219496.protmethod(en-US,SQL.90).gif ms219496.static(en-US,SQL.90).gif Trace  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif UnbindDefaultImpl  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif UnbindRuleImpl  (inherited from SqlSmoObject )
ms219496.protmethod(en-US,SQL.90).gif ms219496.static(en-US,SQL.90).gif UpdateCollectionState2  (inherited from SqlSmoObject )
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft