1 Version 4.0 -- 1/15/89 sp_helpsegment
______________________________________________________________________
NAME: sp_helpsegment
FUNCTION:
Reports information about a database's segments.
SYNTAX:
sp_helpsegment [segname]
EXAMPLES:
sp_helpsegment
Reports information about all the segments in the current database.
sp_helpsegment Version 4.0 -- 1/15/89 2
______________________________________________________________________
sp_helpsegment segment3
Reports information about the segment named segment3, including
which database tables and indexes use that segment.
PARAMETERS:
segname - is the name of the segment about which you want infor-
mation. If you omit this parameter, information on all the
segments is displayed.
COMMENTS:
o Executing sp_helpsegment displays information on the specified
segment when segname is given, or on all segments in sysseg-
ments when no argument is given.
o Segments are added to the syssegments table using the
sp_addsegment stored procedure.
3 Version 4.0 -- 1/15/89 sp_helpsegment
______________________________________________________________________
MESSAGES:
The segment name supplied for the segname parameter doesn't exist
in the syssegments table. Run the procedure without the seg-
name parameter to see a list of all segments for the current
database.
PERMISSIONS:
Execute permission to public.
TABLES USED:
syssegments, sysindexes, master.dbo.sysusages,
master.dbo.sysdevices
SEE ALSO:
sp_addsegment, sp_extendsegment, sp_helpdevice, sp_dropsegment,
sp_helpdb