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_db_increased_partitions
[ [ @dbname = ] N'dbname' ]
[ , [ @increased_partitions = ] 'increased_partitions' ]
[ ; ]
Arguments
[ @dbname = ] N'dbname'
The name of the database. @dbname is sysname, with a default of NULL
.
If @dbname isn't 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 isn't 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.
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for