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_MSgrantconnectreplication(nvarchar @user_name)MetaData:
--
-- Name:
-- sp_MSgrantconnectreplication
--
-- Description:
-- This procedure will grant "connect replication" to the passed in user.
-- This permission is required for NFR to be honored.
--
-- Parameters:
--
-- Returns:
-- 0 - succeeded
-- 1 - failed
--
-- Result:
-- None
--
-- Security:
--
--
create procedure sys.sp_MSgrantconnectreplication
(
@user_name sysname
)
as
begin
declare @command nvarchar(400)
select @command = N'grant connect replication to ' + quotename(@user_name)
exec(@command)
return 0
end
No comments:
Post a Comment