sp_db_increased_partitions
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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for