Edit

sp_db_increased_partitions

  • Article

Applies to: SQL Server

Enables or disables support for up to 15,000 partitions for the specified database.

Important

This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Transact-SQL syntax conventions

Syntax

  
sp_dp_increased_partitions   
[ @dbname ] = 'database_name'   
[ , [ @increased_partitions = ] 'increased_partitions' ] [;]

Arguments

[ @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)

Permissions

Requires ALTER DATABASE permission on the specified database.