June 13, 2012

sp_unregister_custom_scripting (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_unregister_custom_scripting(varchar @type
, nvarchar @publication
, nvarchar @article)

MetaData:

 create procedure sys.sp_unregister_custom_scripting   
(
@type varchar(16) -- one of 'insert', 'delete', 'update', 'custom_script'
,@publication sysname = NULL -- publication to apply this to, NULL means all publications with articles with @schema_option & 0x02 = 0x02
,@article sysname = NULL -- article to apply this to, NULL means all articles with @schema_option & 0x02 = 0x02
)
as
begin
declare @retcode int
exec @retcode = sys.sp_register_custom_scripting @type = @type, @value = NULL, @publication = @publication, @article = @article
return @retcode
end

No comments:

Post a Comment

Total Pageviews