sp_extendsegment

Description

Extends the range of a segment to another database device.

Syntax

sp_extendsegment segname, dbname, devname

Parameters

segname

is the name of the existing segment previously defined with sp_addsegment.

dbname

is the name of the database on which to extend the segment. dbname must be the name of the current database.

devname

is the name of the database device to be added to the current database device range already included in segname.

Examples

Example 1

Extends the range of the segment indexes for the database pubs2 on the database device dev2:

sp_extendsegment indexes, pubs2, dev2

Usage

Permissions

The permission checks for sp_extendsegment differ based on your granular permissions settings.

Granular permissions enabled

With granular permissions enabled, you must be a user with manage database privilege.

Granular permissions disabled

With granular permissions disabled, you must be the database owner or a user with sa_role.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

See also

Commands alter database, create index, create table

System procedures sp_addsegment, sp_dropsegment, sp_helpdb, sp_helpdevice, sp_helpsegment, sp_placeobject