12 lines
638 B
SQL
12 lines
638 B
SQL
EXEC sp_adddistributor @distributor = @@ServerName;
|
|
EXEC sp_adddistributiondb @database = N'distribution';
|
|
|
|
USE [master]
|
|
EXEC sp_adddistpublisher
|
|
@publisher = @@ServerName,
|
|
@distribution_db = N'distribution',
|
|
@security_mode = 0,
|
|
@login = N'sql-repl_agent',
|
|
@password = N'teY^C~7i:x:Ed&pXX|7!',
|
|
@working_directory = N'\\stbagspezlisteprdsql.file.core.windows.net\fs-bagspezlisteprd-replication',
|
|
@storage_connection_string = N'DefaultEndpointsProtocol=https;AccountName=stbagspezlisteprdsql;AccountKey=iM5rSBBgr11oLv654yrotzLGwkEcJyBoZpbbTwiSbDfloyWiYOXERMVyDhc0A/3uwriXdKhSpvOZ+AStjh4ZFg==;EndpointSuffix=core.windows.net'; |