June 15, 2012

xp_repl_convert_encrypt_sysadmin_wrapper (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.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

Total Pageviews