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_MScdc_logddl(int @source_object_id, nvarchar @ddl_command
, binary @ddl_lsn
, nvarchar @ddl_time
, binary @commit_lsn
, int @source_column_id
, bit @fis_alter_column
, bit @fis_drop_table)
MetaData:
create procedure sys.sp_MScdc_logddl ( @source_object_id int ,@ddl_command nvarchar(max) ,@ddl_lsn binary(10) ,@ddl_time nvarchar(1000) ,@commit_lsn binary(10) ,@source_column_id int = null ,@fis_alter_column bit = 0 ,@fis_drop_table bit = 0 ) AS begin set nocount on declare @retcode int ,@db_name sysname -- -- security check - should be dbo or sysadmin -- exec @retcode = sp_MSreplcheck_publish if @@ERROR != 0 or @retcode != 0 return 1 -- -- security check -- Has to be executed from cdc enabled db -- if not exists (select * from sys.databases where database_id = db_id() and is_cdc_enabled = 1) begin set @db_name = db_name() RAISERROR(22901, 16, -1, @db_name) return (1) end -- Switch explicitly to execute as database 'cdc' user execute as user = 'cdc' -- Call internal stored procedure to actually do the work exec @retcode = sys.sp_cdc_logddl_internal @source_object_id ,@ddl_command ,@ddl_lsn ,@ddl_time ,@commit_lsn ,@source_column_id ,@fis_alter_column ,@fis_drop_table -- Revert to authorization of caller revert return @retcode end
No comments:
Post a Comment