Export (0) Print
Expand All

Database Transact-SQL Enhancements

SQL Server 2005

By using the new options in the following Transact-SQL DDL statements, you can work with new features, such as database snapshots, database mirroring, and the snapshot isolation framework. Click the following links for information about these enhancements.

Enhanced statements Description

ALTER DATABASE

Adds the following options:

  • ALLOW_SNAPSHOT_ISOLATION
  • DB_CHAINING
  • Database mirroring
  • DATE_CORRELATION_OPTIMIZATION
  • EMERGENCY (database state option)
  • PAGE_VERIFY (CHECKSUM or TORN_PAGE_DETECTION)
  • PARAMETERIZATION
  • READ_COMMITTED_SNAPSHOT
  • Service Broker
  • TRUSTWORTHY

FILEGROWTH default increment for data files changes from 10 percent to 1 MB.

Instant file initialization when adding or growing data files.

CREATE DATABASE

Adds the following items:

  • DATABASE SNAPSHOT syntax
  • ATTACH_REBUILD_LOG clause
  • DB_CHAINING option
  • Service Broker options
  • TRUSTWORTHY option

FILEGROWTH default increment for data files changes from 10 percent to 1 MB.

Instant file initialization.

DROP DATABASE

Adds support for dropping database snapshots.

Community Additions

ADD
Show:
© 2014 Microsoft