steve.roberts 86619 (1/28/2015)
Hi,Tried to run it yesterday and it ran for five minutes - causing timeouts etc... before I killed it..
Sounds like the result of the query I just added will show 1's for the immediate_sync (which means generate a full snapshot now for the publication) - you must set this to zero USE YOURDB
GO
EXEC sp_changepublication @publication = N'YOURPUBLICATIONNAME', @property = N'allow_anonymous', @value = 'false'
GO
EXEC sp_changepublication @publication = 'YOURPUBLICATIONNAME', @property = N'immediate_sync', @value = 'false'
GO BEFORE running adding the article.
There's no harm in running the code above (it will only help)
It is possible the snapshot agent will pickup where it left off...so there may be some cleanup needed (unsure of this)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience