Database

SMO klasse for en database.

Eksempel

En databases attributter kan læses med dette script (PowerShell):

[System.Reflection.Assembly]::LoadWithPartialName( "Microsoft.SqlServer.Smo" ) | out-null

$server = New-Object "Microsoft.SqlServer.Management.Smo.Server" "."
$server.Databases[ "AdventureWorks" ]

Resultatet kan se således ud:

ExtendedProperties                 : {MS_Description}
DatabaseOptions                    : Microsoft.SqlServer.Management.Smo.DatabaseOptions
Synonyms                           : {}
Tables                             : {AWBuildVersion, DatabaseLog, dtproperties, ErrorLog...}
StoredProcedures                   : {dt_adduserobject, dt_droppropertiesbyid, dt_dropuserobjectbyid, dt_generateansina
                                     me...}
Assemblies                         : {}
UserDefinedTypes                   : {}
UserDefinedAggregates              : {}
FullTextCatalogs                   : {}
Certificates                       : {}
SymmetricKeys                      : {}
AsymmetricKeys                     : {}
ExtendedStoredProcedures           : {sp_AddFunctionalUnitToComponent, sp_batch_params, sp_bindsession, sp_control_dbma
                                     sterkey_password...}
UserDefinedFunctions               : {ufnGetAccountingEndDate, ufnGetAccountingStartDate, ufnGetContactInformation, ufn
                                     GetDocumentStatusText...}
Views                              : {vEmployee, vEmployeeDepartment, vEmployeeDepartmentHistory, vJobCandidate...}
Users                              : {dbo, guest, INFORMATION_SCHEMA, sys}
Schemas                            : {db_accessadmin, db_backupoperator, db_datareader, db_datawriter...}
Roles                              : {db_accessadmin, db_backupoperator, db_datareader, db_datawriter...}
ApplicationRoles                   : {}
LogFiles                           : {AdventureWorks_Log}
FileGroups                         : {PRIMARY}
Defaults                           : {}
Rules                              : {}
UserDefinedDataTypes               : {AccountNumber, Flag, Name, NameStyle...}
XmlSchemaCollections               : {HRResumeSchemaCollection, AdditionalContactInfoSchemaCollection, ManuInstructions
                                     SchemaCollection, ProductDescriptionSchemaCollection...}
PartitionFunctions                 : {}
PartitionSchemes                   : {}
ActiveDirectory                    : [AdventureWorks]
MasterKey                          :
Triggers                           : {ddlDatabaseTriggerLog}
ServiceBroker                      : Microsoft.SqlServer.Management.Smo.Broker.ServiceBroker
IsVarDecimalStorageFormatEnabled   : False
Parent                             : [TITAN]
ActiveConnections                  : 0
AutoCreateStatisticsEnabled        : True
AutoUpdateStatisticsEnabled        : True
CaseSensitive                      : False
Collation                          : SQL_Latin1_General_CP1_CI_AS
CompatibilityLevel                 : Version90
CreateDate                         : 05-06-2007 21:10:45
DatabaseGuid                       : 5956b629-86df-4000-bac0-52194a773d3b
DatabaseSnapshotBaseName           :
DataSpaceUsage                     : 101320
DboLogin                           : True
DefaultFileGroup                   : PRIMARY
DefaultFullTextCatalog             :
DefaultSchema                      : dbo
ID                                 : 6
IndexSpaceUsage                    : 60352
IsAccessible                       : True
IsDatabaseSnapshot                 : False
IsDatabaseSnapshotBase             : False
IsDbAccessAdmin                    : True
IsDbBackupOperator                 : True
IsDbDatareader                     : True
IsDbDatawriter                     : True
IsDbDdlAdmin                       : True
IsDbDenyDatareader                 : False
IsDbDenyDatawriter                 : False
IsDbOwner                          : True
IsDbSecurityAdmin                  : True
IsFullTextEnabled                  : True
IsMailHost                         : False
IsMirroringEnabled                 : False
IsSystemObject                     : False
IsUpdateable                       : True
LastBackupDate                     : 28-06-2007 23:10:33
LastLogBackupDate                  : 01-01-0001 00:00:00
LogReuseWaitStatus                 : Nothing
MirroringFailoverLogSequenceNumber :
MirroringID                        :
MirroringPartner                   :
MirroringPartnerInstance           :
MirroringRoleSequence              :
MirroringSafetyLevel               : None
MirroringSafetySequence            :
MirroringStatus                    : None
MirroringWitness                   :
MirroringWitnessStatus             : None
Owner                              : TITAN\Niels
PrimaryFilePath                    : C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
RecoveryForkGuid                   : b935aac8-bb1a-4c10-ad0b-014dfef2fc72
ReplicationOptions                 : 0
ServiceBrokerGuid                  : 572affec-1533-4477-b592-664953032388
Size                               : 165,9375
SpaceAvailable                     : 0
Status                             : Normal
UserName                           : dbo
Version                            : 611
Events                             : Microsoft.SqlServer.Management.Smo.DatabaseEvents
Name                               : AdventureWorks
Urn                                : Server[@Name='TITAN']/Database[@Name='AdventureWorks']
Properties                         : {ActiveConnections, CompatibilityLevel, CreateDate, DataSpaceUsage...}
UserData                           :
State                              : Existing

Niels Grove-Rasmussen Opdateret 30-01-2008 22:58:40.
Ting Ta'r Tid! Hentet 26-09-2018 00:30:10.