-- 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