The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_db_increased_partitions(nvarchar @dbname, varchar @increased_partitions)
MetaData:
create procedure sys.sp_db_increased_partitions ( @dbname sysname = null, @increased_partitions varchar(6) = null ) as -- If database is not specified then is current database if (@dbname is null) begin set @dbname = DB_NAME(); end -- If ON/OFF parameter is specified then is an action call if @increased_partitions is not null begin if (lower(@increased_partitions) not in ('on', 'off', 'true', 'false')) begin raiserror (15231, 16,1); return (1); end declare @fOnOff bit = 0; set @fOnOff = case lower(@increased_partitions) when 'on' then 1 when 'true' then 1 else 0 end; -- SQL 11: is not possible to disable support, raise informational message if @fOnOff = 0 begin raiserror (657,0,1); end end -- SQL 11: Always ON select cast(1 as bit) as increased_partitions from sys.databases where name = @dbname; return (0);
No comments:
Post a Comment