May 16, 2012

sp_MSgrantconnectreplication (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_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

Total Pageviews