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