April 17, 2012

sp_db_increased_partitions (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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

Total Pageviews