Export (0) Print
Expand All

Database Engine: New and Updated Topics (17 July 2006)

SQL Server 2005

New: 17 July 2006

In the 17 July 2006 release of SQL Server Books Online, the following topics have either been added or updated.

Administration

Architecture

Backup and Restore

Connecting to the SQL Server Database Engine

Databases, Files, and Filegroups

Database Mirroring

Database Mail

Data Manipulation Language (DML)

International Considerations

Metadata

Modules (Stored Procedures, Triggers, and User-Defined Functions)

Monitoring and Tuning Performance

Options

Showplan Operators

SQL Server Agent

Tables, Views, and Indexes

Transaction Logs

Transactions

Transferring Data

Troubleshooting

XML

Microsoft.SqlServer.Management.Smo.Database

Microsoft.SqlServer.Management.Smo.Database.#ctor

Microsoft.SqlServer.Management.Smo.Database.#ctor(Microsoft.SqlServer.Management.Smo.Server,System.String)

Microsoft.SqlServer.Management.Smo.Database.ActiveConnections

Microsoft.SqlServer.Management.Smo.Database.ActiveDirectory

Microsoft.SqlServer.Management.Smo.Database.ApplicationRoles

Microsoft.SqlServer.Management.Smo.Database.Assemblies

Microsoft.SqlServer.Management.Smo.Database.AsymmetricKeys

Microsoft.SqlServer.Management.Smo.Database.AutoCreateStatisticsEnabled

Microsoft.SqlServer.Management.Smo.Database.AutoUpdateStatisticsEnabled

Microsoft.SqlServer.Management.Smo.Database.CaseSensitive

Microsoft.SqlServer.Management.Smo.Database.Certificates

Microsoft.SqlServer.Management.Smo.Database.Collation

Microsoft.SqlServer.Management.Smo.Database.CompatibilityLevel

Microsoft.SqlServer.Management.Smo.Database.CreateDate

Microsoft.SqlServer.Management.Smo.Database.DatabaseOptions

Microsoft.SqlServer.Management.Smo.Database.DatabaseGuid

Microsoft.SqlServer.Management.Smo.Database.DatabaseSnapshotBaseName

Microsoft.SqlServer.Management.Smo.Database.DataSpaceUsage

Microsoft.SqlServer.Management.Smo.Database.DboLogin

Microsoft.SqlServer.Management.Smo.Database.DefaultFileGroup

Microsoft.SqlServer.Management.Smo.Database.DefaultFullTextCatalog

Microsoft.SqlServer.Management.Smo.Database.Defaults

Microsoft.SqlServer.Management.Smo.Database.DefaultSchema

Microsoft.SqlServer.Management.Smo.Database.Events

Microsoft.SqlServer.Management.Smo.Database.ExtendedProperties

Microsoft.SqlServer.Management.Smo.Database.ExtendedStoredProcedures

Microsoft.SqlServer.Management.Smo.Database.FileGroups

Microsoft.SqlServer.Management.Smo.Database.FullTextCatalogs

Microsoft.SqlServer.Management.Smo.Database.ID

Microsoft.SqlServer.Management.Smo.Database.IndexSpaceUsage

Microsoft.SqlServer.Management.Smo.Database.IsAccessible

Microsoft.SqlServer.Management.Smo.Database.IsDatabaseSnapshot

Microsoft.SqlServer.Management.Smo.Database.IsDatabaseSnapshotBase

Microsoft.SqlServer.Management.Smo.Database.IsDbAccessAdmin

Microsoft.SqlServer.Management.Smo.Database.IsDbBackupOperator

Microsoft.SqlServer.Management.Smo.Database.IsDbDatareader

Microsoft.SqlServer.Management.Smo.Database.IsDbDatawriter

Microsoft.SqlServer.Management.Smo.Database.IsDbDdlAdmin

Microsoft.SqlServer.Management.Smo.Database.IsDbDenyDatareader

Microsoft.SqlServer.Management.Smo.Database.IsDbDenyDatawriter

Microsoft.SqlServer.Management.Smo.Database.IsDbOwner

Microsoft.SqlServer.Management.Smo.Database.IsDbSecurityAdmin

Microsoft.SqlServer.Management.Smo.Database.IsFullTextEnabled

Microsoft.SqlServer.Management.Smo.Database.IsMailHost

Microsoft.SqlServer.Management.Smo.Database.IsMirroringEnabled

Microsoft.SqlServer.Management.Smo.Database.IsSystemObject

Microsoft.SqlServer.Management.Smo.Database.IsUpdateable

Microsoft.SqlServer.Management.Smo.Database.LastBackupDate

Microsoft.SqlServer.Management.Smo.Database.LastLogBackupDate

Microsoft.SqlServer.Management.Smo.Database.LogFiles

Microsoft.SqlServer.Management.Smo.Database.MasterKey

Microsoft.SqlServer.Management.Smo.Database.MirroringFailoverLogSequenceNumber

Microsoft.SqlServer.Management.Smo.Database.MirroringID

Microsoft.SqlServer.Management.Smo.Database.MirroringPartnerInstance

Microsoft.SqlServer.Management.Smo.Database.MirroringPartner

Microsoft.SqlServer.Management.Smo.Database.MirroringRoleSequence

Microsoft.SqlServer.Management.Smo.Database.MirroringSafetyLevel

Microsoft.SqlServer.Management.Smo.Database.MirroringSafetySequence

Microsoft.SqlServer.Management.Smo.Database.MirroringStatus

Microsoft.SqlServer.Management.Smo.Database.MirroringWitness

Microsoft.SqlServer.Management.Smo.Database.MirroringWitnessStatus

Microsoft.SqlServer.Management.Smo.Database.Owner

Microsoft.SqlServer.Management.Smo.Database.Parent

Microsoft.SqlServer.Management.Smo.Database.PartitionFunctions

Microsoft.SqlServer.Management.Smo.Database.PartitionSchemes

Microsoft.SqlServer.Management.Smo.Database.PrimaryFilePath

Microsoft.SqlServer.Management.Smo.Database.ReplicationOptions

Microsoft.SqlServer.Management.Smo.Database.Roles

Microsoft.SqlServer.Management.Smo.Database.Rules

Microsoft.SqlServer.Management.Smo.Database.Schemas

Microsoft.SqlServer.Management.Smo.Database.ServiceBroker

Microsoft.SqlServer.Management.Smo.Database.ServiceBrokerGuid

Microsoft.SqlServer.Management.Smo.Database.Size

Microsoft.SqlServer.Management.Smo.Database.SpaceAvailable

Microsoft.SqlServer.Management.Smo.Database.Status

Microsoft.SqlServer.Management.Smo.Database.StoredProcedures

Microsoft.SqlServer.Management.Smo.Database.Synonyms

Microsoft.SqlServer.Management.Smo.Database.SymmetricKeys

Microsoft.SqlServer.Management.Smo.Database.Tables

Microsoft.SqlServer.Management.Smo.Database.Triggers

Microsoft.SqlServer.Management.Smo.Database.UserDefinedAggregates

Microsoft.SqlServer.Management.Smo.Database.UserDefinedDataTypes

Microsoft.SqlServer.Management.Smo.Database.UserDefinedFunctions

Microsoft.SqlServer.Management.Smo.Database.UserDefinedTypes

Microsoft.SqlServer.Management.Smo.Database.UserName

Microsoft.SqlServer.Management.Smo.Database.Users

Microsoft.SqlServer.Management.Smo.Database.Version

Microsoft.SqlServer.Management.Smo.Database.Views

Microsoft.SqlServer.Management.Smo.Database.XmlSchemaCollections

Microsoft.SqlServer.Management.Smo.Database.AddMailUserDatabase(System.String)

Microsoft.SqlServer.Management.Smo.Database.AddMailUserDatabase(System.String,System.String)

Microsoft.SqlServer.Management.Smo.Database.Alter

Microsoft.SqlServer.Management.Smo.Database.Alter(Microsoft.SqlServer.Management.Smo.TerminationClause)

Microsoft.SqlServer.Management.Smo.Database.Alter(System.TimeSpan)

Microsoft.SqlServer.Management.Smo.Database.ChangeMirroringState(Microsoft.SqlServer.Management.Smo.MirroringOption)

Microsoft.SqlServer.Management.Smo.Database.CheckAllocations(Microsoft.SqlServer.Management.Smo.RepairType)

Microsoft.SqlServer.Management.Smo.Database.CheckAllocationsDataOnly

Microsoft.SqlServer.Management.Smo.Database.CheckCatalog

Microsoft.SqlServer.Management.Smo.Database.CheckIdentityValues

Microsoft.SqlServer.Management.Smo.Database.Checkpoint

Microsoft.SqlServer.Management.Smo.Database.CheckTables(Microsoft.SqlServer.Management.Smo.RepairType)

Microsoft.SqlServer.Management.Smo.Database.CheckTablesDataOnly

Microsoft.SqlServer.Management.Smo.Database.Create

Microsoft.SqlServer.Management.Smo.Database.Create(System.Boolean)

Microsoft.SqlServer.Management.Smo.Database.Deny(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String)

Microsoft.SqlServer.Management.Smo.Database.Deny(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String[])

Microsoft.SqlServer.Management.Smo.Database.Deny(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String,System.Boolean)

Microsoft.SqlServer.Management.Smo.Database.Deny(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String[],System.Boolean)

Microsoft.SqlServer.Management.Smo.Database.Drop

Microsoft.SqlServer.Management.Smo.Database.DropBackupHistory

Microsoft.SqlServer.Management.Smo.Database.EnumCandidateKeys

Microsoft.SqlServer.Management.Smo.Database.EnumDatabasePermissions

Microsoft.SqlServer.Management.Smo.Database.EnumDatabasePermissions(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet)

Microsoft.SqlServer.Management.Smo.Database.EnumDatabasePermissions(System.String)

Microsoft.SqlServer.Management.Smo.Database.EnumDatabasePermissions(System.String,Microsoft.SqlServer.Management.Smo.DatabasePermissionSet)

Microsoft.SqlServer.Management.Smo.Database.EnumLocks

Microsoft.SqlServer.Management.Smo.Database.EnumLocks(System.Int32)

Microsoft.SqlServer.Management.Smo.Database.EnumLoginMappings

Microsoft.SqlServer.Management.Smo.Database.EnumMatchingSPs(System.String)

Microsoft.SqlServer.Management.Smo.Database.EnumMatchingSPs(System.String,System.Boolean)

Microsoft.SqlServer.Management.Smo.Database.EnumObjectPermissions

Microsoft.SqlServer.Management.Smo.Database.EnumObjectPermissions(Microsoft.SqlServer.Management.Smo.ObjectPermissionSet)

Microsoft.SqlServer.Management.Smo.Database.EnumObjectPermissions(System.String)

Microsoft.SqlServer.Management.Smo.Database.EnumObjectPermissions(System.String,Microsoft.SqlServer.Management.Smo.ObjectPermissionSet)

Microsoft.SqlServer.Management.Smo.Database.EnumObjects

Microsoft.SqlServer.Management.Smo.Database.EnumObjects(Microsoft.SqlServer.Management.Smo.DatabaseObjectTypes)

Microsoft.SqlServer.Management.Smo.Database.EnumObjects(Microsoft.SqlServer.Management.Smo.DatabaseObjectTypes,Microsoft.SqlServer.Management.Smo.SortOrder)

Microsoft.SqlServer.Management.Smo.Database.EnumTransactions

Microsoft.SqlServer.Management.Smo.Database.EnumTransactions(Microsoft.SqlServer.Management.Smo.TransactionTypes)

Microsoft.SqlServer.Management.Smo.Database.EnumWindowsGroups

Microsoft.SqlServer.Management.Smo.Database.EnumWindowsGroups(System.String)

Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(System.String)

Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(System.Collections.Specialized.StringCollection)

Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(System.String,Microsoft.SqlServer.Management.Common.ExecutionTypes)

Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(System.Collections.Specialized.StringCollection,Microsoft.SqlServer.Management.Common.ExecutionTypes)

Microsoft.SqlServer.Management.Smo.Database.ExecuteWithResults(System.String)

Microsoft.SqlServer.Management.Smo.Database.ExecuteWithResults(System.Collections.Specialized.StringCollection)

Microsoft.SqlServer.Management.Smo.Database.GetTransactionCount

Microsoft.SqlServer.Management.Smo.Database.GetTransactionCount(Microsoft.SqlServer.Management.Smo.TransactionTypes)

Microsoft.SqlServer.Management.Smo.Database.Grant(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String)

Microsoft.SqlServer.Management.Smo.Database.Grant(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String[])

Microsoft.SqlServer.Management.Smo.Database.Grant(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String,System.Boolean)

Microsoft.SqlServer.Management.Smo.Database.Grant(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String[],System.Boolean)

Microsoft.SqlServer.Management.Smo.Database.Grant(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String,System.Boolean,System.String)

Microsoft.SqlServer.Management.Smo.Database.Grant(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String[],System.Boolean,System.String)

Microsoft.SqlServer.Management.Smo.Database.IsMember(System.String)

Microsoft.SqlServer.Management.Smo.Database.MarkDropped

Microsoft.SqlServer.Management.Smo.Database.PostCreate

Microsoft.SqlServer.Management.Smo.Database.PrefetchObjects

Microsoft.SqlServer.Management.Smo.Database.PrefetchObjects(System.Type)

Microsoft.SqlServer.Management.Smo.Database.PrefetchObjects(System.Type,System.Boolean)

Microsoft.SqlServer.Management.Smo.Database.PrefetchObjects(System.Type,Microsoft.SqlServer.Management.Smo.ScriptingOptions)

Microsoft.SqlServer.Management.Smo.Database.RecalculateSpaceUsage

Microsoft.SqlServer.Management.Smo.Database.Refresh

Microsoft.SqlServer.Management.Smo.Database.RemoveFullTextCatalogs

Microsoft.SqlServer.Management.Smo.Database.RemoveMailUserDatabase(System.String)

Microsoft.SqlServer.Management.Smo.Database.Rename(System.String)

Microsoft.SqlServer.Management.Smo.Database.Revoke(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String)

Microsoft.SqlServer.Management.Smo.Database.Revoke(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String[])

Microsoft.SqlServer.Management.Smo.Database.Revoke(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String,System.Boolean,System.Boolean)

Microsoft.SqlServer.Management.Smo.Database.Revoke(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String[],System.Boolean,System.Boolean)

Microsoft.SqlServer.Management.Smo.Database.Revoke(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String,System.Boolean,System.Boolean,System.String)

Microsoft.SqlServer.Management.Smo.Database.Revoke(Microsoft.SqlServer.Management.Smo.DatabasePermissionSet,System.String[],System.Boolean,System.Boolean,System.String)

Microsoft.SqlServer.Management.Smo.Database.Script

Microsoft.SqlServer.Management.Smo.Database.Script(Microsoft.SqlServer.Management.Smo.ScriptingOptions)

Microsoft.SqlServer.Management.Smo.Database.SetDefaultFileGroup(System.String)

Microsoft.SqlServer.Management.Smo.Database.SetDefaultFullTextCatalog(System.String)

Microsoft.SqlServer.Management.Smo.Database.SetOffline

Microsoft.SqlServer.Management.Smo.Database.SetOnline

Microsoft.SqlServer.Management.Smo.Database.SetOwner(System.String)

Microsoft.SqlServer.Management.Smo.Database.SetOwner(System.String,System.Boolean)

Microsoft.SqlServer.Management.Smo.Database.Shrink(System.Int32,Microsoft.SqlServer.Management.Smo.ShrinkMethod)

Microsoft.SqlServer.Management.Smo.Database.TruncateLog

Microsoft.SqlServer.Management.Smo.Database.UpdateIndexStatistics

Microsoft.SqlServer.Management.Smo.Database.RecoveryForkGuid

Microsoft.SqlServer.Management.Smo.Database.LogReuseWaitStatus

Arrow icon used with Back to Top link Back to Top

Community Additions

ADD
Show:
© 2014 Microsoft