May 14, 2012

sp_MSenumschemachange (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_MSenumschemachange(uniqueidentifier @pubid
, int @schemaversion
, int @compatlevel
, bit @AlterTableOnly
, bit @invalidateupload_schemachanges_for_ssce
, bit @filter_skipped_schemachanges)

MetaData:

   
create procedure sys.sp_MSenumschemachange(
@pubid uniqueidentifier,
@schemaversion int,
@compatlevel int = 7000000, -- default=SPHINX
@AlterTableOnly bit = 0,
@invalidateupload_schemachanges_for_ssce bit = 0,
@filter_skipped_schemachanges bit = 0
)
as
begin
set nocount on
declare @retcode int

select @retcode = 0

if ({ fn ISPALUSER(@pubid) } <> 1)
begin
RAISERROR (14126, 11, -1)
return (1)
end

-- Delegate call to the appropriate sp that
-- handles the given compatibility-level

if @compatlevel >= 10000000
begin
exec @retcode = sys.sp_MSenumschemachange_100 @pubid = @pubid,
@AlterTableOnly = @AlterTableOnly,
@schemaversion = @schemaversion,
@invalidateupload_schemachanges_for_ssce = @invalidateupload_schemachanges_for_ssce,
@filter_skipped_schemachanges = @filter_skipped_schemachanges

end
else if @compatlevel >= 9000000
begin
exec @retcode = sys.sp_MSenumschemachange_90 @pubid = @pubid,
@AlterTableOnly = @AlterTableOnly,
@schemaversion = @schemaversion,
@invalidateupload_schemachanges_for_ssce = @invalidateupload_schemachanges_for_ssce,
@filter_skipped_schemachanges = @filter_skipped_schemachanges

end
else if @compatlevel >= 8000500 -- this value stands for 80sp3
begin
exec @retcode = sp_MSenumschemachange_80sp3 @pubid = @pubid,
@AlterTableOnly = @AlterTableOnly,
@schemaversion = @schemaversion

end
else if @compatlevel > 7000200 -- this value standing for 70SP2
begin
exec @retcode = sys.sp_MSenumschemachange_80 @pubid = @pubid,
@AlterTableOnly = @AlterTableOnly,
@schemaversion = @schemaversion
end
else
begin
exec @retcode = sys.sp_MSenumschemachange_70 @pubid = @pubid,
@AlterTableOnly = @AlterTableOnly,
@schemaversion = @schemaversion,
@compatlevel=@compatlevel
end

return @retcode
end

No comments:

Post a Comment

Total Pageviews