Database Engine: New and Updated Topics (17 July 2006)
New: 17 July 2006
In the 17 July 2006 release of SQL Server Books Online, the following topics have either been added or updated.
Topic Categories
New Conceptual and Task Topics
Updated Conceptual and Task Topics
New Reference Topics
Updated Reference Topics
Updated Managed Reference Topics
New Conceptual and Task Topics
Memory Used by SQL Server Objects Specifications
Security
How to: Back Up a Database Master Key
How to: Back Up the Service Master Key
How to: Create a Database Master Key
How to: Restore a Database Master Key
How to: Restore the Service Master Key
Managing Logins and Users How-to Topics
How to: Create a Database User
Visual Database Tools
How to: Add Derived Tables to Queries (Visual Database Tools)
How to: Assign an XML Schema Collection to an XML Data Type (Visual Database Tools)
How to: Change Column Order (Visual Database Tools)
How to: Copy an Image of a Database Diagram to the Clipboard (Visual Database Tools)
How to: Copy Query Results (Visual Database Tools)
How to: Create Relationships Between Tables on a Diagram (Visual Database Tools)
How to: Duplicate Tables (Visual Database Tools)
How to: Open Tables (Visual Database Tools)
How to: Rename Tables (Visual Database Tools)
How to: Show Data from a Table (Visual Database Tools)
Walkthrough: Adding and Changing a Database Diagram
Working with Tables in Table Designer (Visual Database Tools)
.gif "Arrow icon used with Back to Top link")
Back to Top
Updated Conceptual and Task Topics
Administration
Failover Cluster Troubleshooting
Architecture
Execution Plan Caching and Reuse
Backup and Restore
Backing Up Read-Only Databases
Backup Under the Bulk-Logged Recovery Model
Backup Under the Full Recovery Model
Backup Under the Simple Recovery Model
Introduction to Transaction Logs
Media Sets, Media Families, and Backup Sets
Overview of Restore and Recovery in SQL Server
Restore Restrictions Under the Simple Recovery Model
Restore Under the Bulk-Logged Recovery Model
Performing File Restores (Full Recovery Model)
Security Considerations for Backup and Restore
Using Marked Transactions (Full Recovery Model)
Viewing Information About Backups
Working with Transaction Log Backups
Connecting to the SQL Server Database Engine
Configuring Linked Servers for Delegation
Encrypting Connections to SQL Server
Databases, Files, and Filegroups
Data File Auto Shrink Event Class
Detaching and Attaching Databases
Log File Auto Shrink Event Class
Database Mirroring
Database Mirroring and Full-Text Catalogs
Possible Failures During Database Mirroring
Quorum: How a Witness Affects Database Availability
Replication and Database Mirroring
Database Mail
Troubleshooting Database Mail: Mail queued, not delivered
Data Manipulation Language (DML)
Using TRY...CATCH in Transact-SQL
International Considerations
Managing Data Conversion Between Client/Server Code Pages
Server-Side Programming with Unicode
Writing International Transact-SQL Statements
Metadata
Querying the SQL Server System Catalog FAQ
Managing Metadata When Making a Database Available on Another Server Instance
Modules (Stored Procedures, Triggers, and User-Defined Functions)
Deterministic and Nondeterministic Functions
Using the inserted and deleted Tables
Returning Data by Using a Return Code
Specifying the Direction of a Parameter
Monitoring and Tuning Performance
Data File Auto Shrink Event Class
Log File Auto Shrink Event Class
How to: Correlate a Trace with Windows Performance Log Data (SQL Server Profiler)
Tools for Performance Monitoring and Tuning
Trace Events for Use with Event Notifications
Options
Showplan Operators
Clustered Index Delete Showplan Operator
Clustered Index Insert Showplan Operator
Clustered Index Scan Showplan Operator
Clustered Index Seek Showplan Operator
Clustered Index Update Showplan Operator
Stream Aggregate Showplan Operator
SQL Server Agent
Tables, Views, and Indexes
Creating and Modifying CHECK Constraints
Reorganizing and Rebuilding Indexes
Transaction Logs
Choosing the Recovery Model for a Database
Creating Transaction Log Backups
Factors That Can Delay Log Truncation
Introduction to Transaction Logs
Transactions
Guidelines for Using Distributed Queries
OLE DB Provider for Microsoft Directory Services
Using TRY...CATCH in Transact-SQL
Transferring Data
Importing and Exporting Bulk Data by Using the bcp Utility
Importing Bulk Data by Using BULK INSERT or OPENROWSET(BULK...)
Preparing Data for Bulk Export or Import
Using a Format File to Skip a Table Column
Troubleshooting
Failover Cluster Troubleshooting
Troubleshooting Database Mail: Mail queued, not delivered
Troubleshooting Database Mirroring Setup
XML
Guidelines and Limitations in Native XML Web Services
Back to Top
New Reference Topics
Language Reference: New and Updated Topics (17 July 2006)
Back to Top
Updated Reference Topics
Language Reference: New and Updated Topics (17 July 2006)
Back to Top
Updated Managed Reference Topics
Microsoft.SqlServer.Management.Smo.Database
Microsoft.SqlServer.Management.Smo.Database.#ctor
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(System.TimeSpan)
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.CheckTablesDataOnly
Microsoft.SqlServer.Management.Smo.Database.Create
Microsoft.SqlServer.Management.Smo.Database.Create(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(System.String)
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(System.String)
Microsoft.SqlServer.Management.Smo.Database.EnumObjects
Microsoft.SqlServer.Management.Smo.Database.EnumTransactions
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.ExecuteWithResults(System.String)
Microsoft.SqlServer.Management.Smo.Database.GetTransactionCount
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.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.Script
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.TruncateLog
Microsoft.SqlServer.Management.Smo.Database.UpdateIndexStatistics
Microsoft.SqlServer.Management.Smo.Database.RecoveryForkGuid
Microsoft.SqlServer.Management.Smo.Database.LogReuseWaitStatus
Back to Top
See Also
Concepts
New and Updated Topics in Previous Releases of Books Online
Error Messages: New and Updated Topics (17 July 2006)
Tools and Utilities Reference: New and Updated Topics (17 July 2006)