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_MS_replication_installed()MetaData:
--
-- Name: sp_MS_replication_installed
--
-- Descriptions:
--
-- Parameters: as defined in create statement
--
-- Returns: 0 - success
-- 1 - Otherwise
--
-- Security:
-- Requires Certificate signature for catalog access
--
create procedure sys.sp_MS_replication_installed
as
set nocount on
declare @isinstalled int
select @isinstalled = 0
declare @retcode int
EXECUTE @retcode = master.dbo.xp_instance_regread 'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\MSSQLServer\Replication',
'IsInstalled',
@param = @isinstalled OUTPUT
IF ( @retcode <> 0 ) or ( @@ERROR <> 0 )
begin
raiserror (21028, 16, -1)
return (0)
end
if (@isinstalled is null or @isinstalled = 0)
begin
raiserror (21028, 16, -1)
return (0)
end
return (1)
No comments:
Post a Comment