Database Transact-SQL Enhancements

  • Article

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 DDL Statements

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.

See Also

Reference

Data Definition Language (DDL) Statements (Transact-SQL)

Other Resources

What's New and Enhanced in Transact-SQL (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance