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