Reports the partition name, segment name, and date created for the specified object.
sp_objectsegment object_name
Name of the object in question. Acceptable objects are:
System tables
Views
User tables
System procedures
Defaults
Rules
Triggers
Referential constraints
Check constraints
Extended types
Functions
Computed columns
Partitions
Reports information about the authors table:
sp_objectsegment authors
Partition_name Data_located_on_segment When_created ----------------- ----------------------- ------------ auidind_576002052 default Feb 9 2012 11:18AM
Any user may run sp_objectsegment
