Erstellen einer Distributionsdatenbank

CreateDistributionDatabase.sql

USE master
GO
exec sp_adddistributiondb
    @database = N'Distrib-PLZ74',
    @data_folder = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data',
    @log_folder = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data',
    @data_file_size = 5,
    @log_file_size = 5,
    @min_distretention = 0,
    @max_distretention = 24,
    @history_retention = 24,
    @security_mode = 1
GO