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_MSreplcheck_subscribe()MetaData:
create procedure sys.sp_MSreplcheck_subscribe
as
begin
--
-- Only the System Administratr (SA) or the Database Owner (dbo)
-- can subscribe from the subscribing database.
--
-- Do the sysadmin check first as it is 4 times more efficient
-- than is_member call and reduces performance overhead in case
-- the user has sysadmin privileges
--
if is_srvrolemember('sysadmin') = 1 or is_member ('db_owner') = 1
begin
return (0)
end
else
begin
raiserror (21050, 14, -1)
return (1)
end
end
No comments:
Post a Comment