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