create procedure sys.sp_MScreate_subscription_properties_table as
begin
    create table dbo.MSsubscription_properties
    (
        publisher                    sysname    not null,
        publisher_db                sysname    null,
        publication                    sysname    not null,
        publication_type            int    not null,
        publisher_login                sysname    null,           -- remove in subsequent release
        publisher_password            nvarchar(524) null,   -- remove in subsequent release
        publisher_security_mode        int    not null,
        distributor                    sysname    null,
        distributor_login            sysname    null,
        distributor_password        nvarchar(524) null,
        distributor_security_mode    int    not null,
        ftp_address                    sysname    null,
        ftp_port                    int    null,
        ftp_login                    sysname    null,
        ftp_password                nvarchar(524) null,
        alt_snapshot_folder            nvarchar(255) null,
        working_directory            nvarchar(255) null,
        use_ftp                        bit default 0 not null,
        dts_package_name            sysname null,
        dts_package_password        nvarchar(524) null,
        dts_package_location        int    default 1 not null,
        enabled_for_syncmgr            bit default 0 not null,
        offload_agent                bit default 0 not null,
        offload_server                sysname null,
        dynamic_snapshot_location    nvarchar(255) null,
        use_web_sync                bit default 0 NOT NULL,
        internet_url                nvarchar(260) NULL,
        internet_login                sysname        NULL,
        internet_password            nvarchar(524)    NULL,
        internet_security_mode        int            NOT NULL default 0,
        internet_timeout            int    NOT NULL default 300,
        hostname                    sysname        NULL,
        publisherlink sysname NULL,
        publisherlinkuser sysname NULL,
        job_step_uid                uniqueidentifier
    )

    if @@error <> 0 return 1

    create unique clustered index uc1MSsubscription_properties on
            MSsubscription_properties(publication, publisher_db, publisher)
    if @@error <> 0    return 1

    exec dbo.sp_MS_marksystemobject MSsubscription_properties
    if @@error <> 0 return 1

    return 0
end