"Ron" <Ron@discussions.microsoft.com> wrote in message
news:3B62D9E3-FDC8-4710-8C72-8F49C9C8F237@microsoft.com...
>I tried adding a new stored procedure to the publishing database and then
> added it to the articles to be published. It never went over to the
> subscription database. When/how does the snapshot get automatically
> generated and distributed for this new article?
>
> Thanks.
>
>
> "Hilary Cotter" wrote:
>
>> Most schema changes will be replicated as long as you have the
>> replicate_ddl
>> parameter set to true.
>>
>> If you don't know what this setting is, chances are you have accepted the
>> defaults and by default this is set to true (1).
>>
>> The snapshot will be automatically generated and distributed for this
>> article only.
>>
>> --
>> RelevantNoise.com - dedicated to mining blogs for business intelligence.
>>
>> 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
>> "Ron" <Ron@discussions.microsoft.com> wrote in message
>> news:7922238A-CF7A-4C52-B1B5-21115D201D76@microsoft.com...
>> > SQL2005 sp1
>> >
>> > Once transactional replication is set up and running,
>> >
>> > Will changing a table's structure (new column or new or changed SP) be
>> > carried over to the replicated database?
>> >
>> > Will it result in a replication failure and cause replication to stop?
>> >
>> > Does a snapshot automatically run or do you need to run it once an
>> > object
>> > has been changed?
>> >
>> > Thanks
>> >
>> > Ron
>>
>>
>>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:O6jchRLHIHA.4476@TK2MSFTNGP06.phx.gbl...
> there is a proc to start the snapshot.
>
> sp_startpublication_snapshot
>
> Forgot to mention it.
>
> --
> RelevantNoise.com - dedicated to mining blogs for business intelligence.
>
> 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
> "Ron" <Ron@discussions.microsoft.com> wrote in message
> news:3B62D9E3-FDC8-4710-8C72-8F49C9C8F237@microsoft.com...
>>I tried adding a new stored procedure to the publishing database and then
>> added it to the articles to be published. It never went over to the
>> subscription database. When/how does the snapshot get automatically
>> generated and distributed for this new article?
>>
>> Thanks.
>>
>>
>> "Hilary Cotter" wrote:
>>
>>> Most schema changes will be replicated as long as you have the
>>> replicate_ddl
>>> parameter set to true.
>>>
>>> If you don't know what this setting is, chances are you have accepted
>>> the
>>> defaults and by default this is set to true (1).
>>>
>>> The snapshot will be automatically generated and distributed for this
>>> article only.
>>>
>>> --
>>> RelevantNoise.com - dedicated to mining blogs for business intelligence.
>>>
>>> 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
>>> "Ron" <Ron@discussions.microsoft.com> wrote in message
>>> news:7922238A-CF7A-4C52-B1B5-21115D201D76@microsoft.com...
>>> > SQL2005 sp1
>>> >
>>> > Once transactional replication is set up and running,
>>> >
>>> > Will changing a table's structure (new column or new or changed SP) be
>>> > carried over to the replicated database?
>>> >
>>> > Will it result in a replication failure and cause replication to stop?
>>> >
>>> > Does a snapshot automatically run or do you need to run it once an
>>> > object
>>> > has been changed?
>>> >
>>> > Thanks
>>> >
>>> > Ron
>>>
>>>
>>>
>
>