Groups | Blog | Home
all groups > sql server replication > february 2005 >

sql server replication : what is @force_invalidate_snapshot


Hassan
2/28/2005 11:04:01 PM
I cant seem to understand the use of this parameter. Can someone help me
understand this in very basic replication terms ?

Hilary Cotter
3/1/2005 6:45:14 AM
when you change certain properties of a publication or article an error
message is raised saying that a reinitialization is required, and with
@force_invalidate_snapshot set to 0 the change will be rolled back.

with @force_invalidate_snapshot this error will not be raised and the change
will not be rolled back.

Most people will want to know that they are making a change which will
require reinitialization, regeneration, and redistribution of their
snapshot. They also want to the option to confirm that this is really what
they want to do, i.e. in a script, and they are prepared for the
reinitialization, regeneration, and redistribution of their snapshot.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

Hassan
3/1/2005 1:39:04 PM
What error and what change are you referring to ?

[quoted text, click to view]

AddThis Social Bookmark Button