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