Changes to system procedures

The following system procedures have been changed in this release:

Table 6-5: Changes to system procedures

Procedure

Change

sp_dboption

Has a new database option, identity in nonunique index, that allows you to create a unique index by including an IDENTITY column in the index key.

sp_configure

Includes new parameters and new optional subcommands, and displays new output.