Making single table snapshot using sql server 2005 enterprise

[georgeg]

I have created a publisher and snapshot some of the tables, which are
published to a subscriber.
Now I would like to snapshot a single table for this publisher. I checked
the table and start the snapshot agent, but it starts to snapshot all the
tables taht were snapshot before. Is ther some way to do this without doing a
snapshot of all the other tables?

Thanks
--
George Gopie

[georgeg]

Does anyone knows if ther is bug in Sql server 2005 Enterprise edition 64bit
for this issue? I was able to do this in sql server 2000 enterorise edition
withot any problems.

Thanks,
--
George Gopie

[Paul Ibison]

George,

this is expected behaviour if you have a merge or snapshot publication. If
you have a transactional publication, a snapshot of all articles will always
be generated if the immediate_sync publication property is set to true.
Typically, the immediate_sync publication property is set to true if you
allowed anonymous subscriptions while creating the publication through the
CreatePublication wizard. To prevent the complete snapshot, run the script
below:

EXEC sp_changepublication
@publication = 'MainPub',
@property = N'allow_anonymous',
@value = 'false'
GO

EXEC sp_changepublication
@publication = 'MainPub',
@property = N'immediate_sync',
@value = 'false'
GO

HTH,
Paul Ibison (www.replicationanswers.com)