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.xp_repl_convert_encrypt_sysadmin_wrapper()MetaData:
-- -- Name: xp_repl_convert_encrypt_sysadmin_wrapper -- -- Descriptions: -- -- Parameters: as defined in create statement -- -- Returns: 0 - success -- 1 - Otherwise -- -- Security: -- Requires Certificate signature for catalog access -- create procedure sys.xp_repl_convert_encrypt_sysadmin_wrapper ( @password nvarchar(524) output ) as begin set nocount on declare @retcode int -- -- Security Check: require sysadmin -- if (isnull(is_srvrolemember('sysadmin'),0) = 0) begin raiserror(21089,16,-1) return (1) end -- if we have sphinx/shiloh encryption go ahead and convert if sys.fn_replencryptversion(@password) in (1, 2, 3) begin exec @retcode = sys.xp_repl_convert_encrypt @password output return @retcode end return 0 end
No comments:
Post a Comment