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