-- Name: sp_MSsubscription_enabled_for_syncmgr
-- Descriptions:
-- Parameters: as defined in create statement
-- Returns: 0 - success
-- 1 - Otherwise
-- Security:
-- Requires Certificate signature for catalog access
create procedure sys.sp_MSsubscription_enabled_for_syncmgr
(
@publisher sysname = NULL,
@publisher_db sysname = NULL,
@publication sysname = NULL,
@subscriber sysname = NULL,
@subscriber_db sysname = NULL,
@enabled int = NULL OUTPUT,
@regkey nvarchar(1000) = NULL OUTPUT
)
AS
BEGIN
-- Drop the corresponding registry entry for MobileSync
declare @keyexist int
-- no reg key to clean up for virtual subscribers
if @subscriber is null
begin
select @enabled = 0
return 0
end
SET @regkey = sys.fn_replgetsubscriptionregkey(@publisher, @publisher_db, @publication, @subscriber, @subscriber_db)
BEGIN
CREATE TABLE #keyexist (keyexist int)
INSERT INTO #keyexist
EXEC master.dbo.xp_regread 'HKEY_LOCAL_MACHINE', @regkey
SELECT @enabled = keyexist
FROM #keyexist
DROP TABLE #keyexist
END
return 0
END