sql server replication: Wojciech ,
there is a difference between creating a publication and synchronizing data
for an existing publication. The publication can be created and as long as
the logreader and distribution agents don't run (no synchronization) there
is no effect on the publisher. Typically the log reader runs continuously,
but you can schedule the distribution agent to run whenever you want. If
this also runs continuously and you want to enforce a delay, you could
increase the POLLINGINTERVAL parameter's value. Other parameters you might
be interested in are -CommitBatchThreshold, CommitBatchSize,
MaxDeliveredTransactions.
HTH,
Paul Ibison

Hello
Is it possible that the Publisher could wait some time ( about 15 seconds)
before it starts publishing ?
I want it to start publishing when it gets new data, but there can be about
1000 new records in few seconds and I think it would be better to
wait for few seconds then to create new publication after single record is
inserted.

Best Regards
Wojciech Znaniecki

Wojtek,
using sp_addsubscriber will allow you to set the frequency for the
distribution agent. However, the easeist way to do what you require is to
create the publication without starting the snapshot agent. Then edit the
logreader and distribution agent jobs to run on a schedule.
HTH,
Paul Ibison

Thanks for fast anwser
I've tried to do it but I cant create a publication with stopped
Distribution Agent and Log Reader Agent.
Can I do it with sql script?

for example: my script that create Publication looks like that :
"(...)
exec sp_addpublication @publication = N'RozkazyReplikacja', @restricted =
N'false', @sync_method = N'native', @repl_freq = N'continuous', @description
= N'Transactional publication of replikacyjna database from Publisher
WOJTEK-Z\W1.', @status = N'active', @allow_push = N'true', @allow_pull =
N'true', @allow_anonymous = N'false', @enabled_for_internet = N'false',
@independent_agent = N'false', @immediate_sync = N'false', @allow_sync_tran
= N'false', @autogen_sync_procs = N'false', @retention = 336,
@allow_queued_tran = N'false', @snapshot_in_defaultfolder = N'true',
@compress_snapshot = N'false', @ftp_port = 21, @ftp_login = N'anonymous',
@allow_dts = N'false', @allow_subscription_copy = N'false',
@add_to_active_directory = N'false', @logreader_job_name =
N'WOJTEK-Z\W1-replikacyjna-5'

exec sp_addpublication_snapshot @publication = N'RozkazyReplikacja',
@frequency_type = 4, @frequency_interval = 1, @frequency_relative_interval =
0, @frequency_recurrence_factor = 1, @frequency_subday = 4,
@frequency_subday_interval = 1, @active_start_date = 0, @active_end_date =
0, @active_start_time_of_day = 0, @active_end_time_of_day = 235959,
@snapshot_job_name = N'WOJTEK-Z\W1-replikacyjna-RozkazyReplikacja-7'

GO

(...) "
What should i change to create publication without starting Distribution and
Log Reader Agent ?

Best Regards
Wojciech Znaniecki