Error 17737



Message text

Partitioned objects cannot be moved.


Adaptive Server does not allow you to use sp_placeobject on partitioned objects. Error 17737 occurs when you try to use sp_placeobject to change future space allocations on a partitioned table.


To use sp_placeobject on the table:

  1. Use the unpartition clause of the alter table command to concatenate all partitions:

    1> alter table <table_name> unpartition
    2> go
  2. Run the sp_placeobject command again.

Additional information

Refer to the Reference Manual: Commands for information about alter table Reference Manual: Procedures for details about sp_placeobject.

Versions in which this error is raised

All versions