What are these "CREATE PUBLICATION dummy_pub_1" statements for?

[VolkerBarth]

What's the use of these strage statements in a reload.sql script for a SQL Remote database:

CREATE PUBLICATION dummy_pub_1( TABLE dbo.RowGenerator )
go
DROP PUBLICATION dummy_pub_1
go

CREATE PUBLICATION dummy_pub_2( TABLE dbo.RowGenerator )
go
DROP PUBLICATION dummy_pub_2
go

CREATE PUBLICATION "dbo"."PUB_ArtTabellen" 
(

Are these dummy publications just created to assure that the real publications have the same publication_ids as in the original database?

[Former Member · Accepted solution]

Yes, that is exactly the reason. Publication id's can be recorded in the transaction log. Preserving the id's allows logs created prior to the database rebuild to be accessed by SQL Remote without compatibility issues. Otherwise all remote databases would need to be sync'ed before the rebuild (unlikely), or those not synced would need to be re-extracted after the rebuild.

[VolkerBarth · Accepted solution]

Well, that's reason enough...thanks for the clarification. I guess the same background applies to the "GRANT CONNECT ... AT n" statements to assure remote users have the same user IDs as before?