Enables or disables support for up to 15,000 partitions for the specified database.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
sp_dp_increased_partitions [ @dbname ] = 'database_name' [ , [ @increased_partitions = ] 'increased_partitions' ] [;]
[ @dbname= ] 'database_name'
Is the name of the database. dbname is sysname with a default value of NULL. If dbname is not specified, the current database is used.
[ @increased_partitions= ] 'increased_partitions'
Enables or disables support for 15,000 partitions on the specified database. increased_partitions is varchar(6) with a default of NULL. Accepted values are 'ON' or 'TRUE' to enable support and 'OFF' or 'FALSE' to disable support. If increased_partitions is not specified, the procedure returns 1 to indicate support is enabled for the specified database or 0 to indicate support is disabled.
Return Code Values
0 (success) or 1 (failure)
Requires ALTER DATABASE permission on the specified database.