Skip to content

Instantly share code, notes, and snippets.

@florianbeisel

florianbeisel/addDistributionDatabaseToPublisher.sql

Created October 14, 2011 06:41
Show Gist options
  • Save florianbeisel/1286417 to your computer and use it in GitHub Desktop.
Save florianbeisel/1286417 to your computer and use it in GitHub Desktop.
Download ZIP
Distributionsdatenbank einem Publisher zuzuweisen
Raw
addDistributionDatabaseToPublisher.sql
exec sp_adddistpublisher
@publisher = N'DEVELOPMENT',
@distribution_db = N'Distrib-PLZ74',
@security_mode = 1, -- Trusted Security
@working_directory = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\ReplData',
@trusted = N'false', -- deprecated
@thirdparty_flag = 0, -- SQL Server
@publisher_type = N'MSSQLSERVER'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment