Changed Transact-SQL commands

alter role

Includes new lock, unlock, and all overrides options to change the lock status of a role.

Includes new passwd expiration, max failed_logins, and min passwd length options to change the password expiration interval, the minimum password length, and the maximum number of failed logins allowed for a specified role.

alter table

Includes new off row and in row options to specify storage for Java-SQL columns.

create role

Includes new lock, unlock, and all overrides options to set the lock status of a role.

Includes new passwd expiration, min passwd length, max failed_logins options to set the password expiration interval, the minimum password length, and the maximum number of failed logins allowed for a specified role.

create table

Includes new off row and in row options to specify storage for Java-SQL columns.

dbcc

Includes new commands for heuristically completing distributed transactions.

Includes new rebuild_text command for rebuilding or creating internal data structures for text or image data. Adaptive Server uses these data structures to perform random access and asynchronous prefetch for queries against text or image data.

disk init

Includes the new dsync option to control buffered writes to devices.

disk reinit

Includes the new dsync option to control buffered writes to devices.

execute

Includes the new execute() syntax to dynamically execute Transact-SQL commands.