how to auto restart the merge agent

I have a merge replication, the merge agent job failed with:
step 2 :
could not retrieve generation information at the 'Subscriber'. NOTE: The
step was retried the requested number of times (10) without succeeding. The
step failed.
step 3:
The merge agent job failed. The merge process could not retrieve generation
information at the 'Subscriber'. NOTE: The step was retried the requested
number of times (10) without succeeding. The step failed. [SQLSTATE 42000]
(Error 14151). The step failed.
I am not sure what had caused the merge agent to fail but after I restarted
the merge agent , it automatically caught up. I would like to know if there
is a way to automatically re-start the merge agent after the system restored.
Thanks in advance for any help.
Wen Chang
Wen,
I'm not too sure what you mean by setting it off when the system gets
restarted. If you mean have it keep trying, then you could loop the steps in
the merge agent's job. Alternatively you could have it run on a schedule and
not continuously - eg once each minute.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

How to add the Column in Table which is in replication

Dear Friends
I have setup a merge replicaion between my two servers
and now i want to add some column in one table kindly
suggest how i can do the same without stoping the
replicaiton.
your earlier reply will guide me to solve the problem.
Best regards
Sharad
Sharad,
have a look in BOL for the command sp_repladdcolumn.
HTH,
Paul Ibison
|||Dear Fiend
Getting the following error.
Server: Msg 8114, Level 16, State 4, Procedure
sp_repladdcolumn, Line 0
Error converting data type nvarchar to bit.
for the code
sp_repladdcolumn @.source_object = 'OTHALLOCATION'
, @.column = 'CCICAPPNUM'
, @.typetext = 'NVARCHAR(50)'
, @.publication_to_add = 'GEMREPLGNETINFOTECH'
, @.schema_change_script = ''
, @.force_invalidate_snapshot =
force_invalidate_snapshot
, @.force_reinit_subscription =
force_reinit_subscription
Please suggest.
Best regards
Shailesh

>--Original Message--
>Sharad,
>have a look in BOL for the command sp_repladdcolumn.
>HTH,
>Paul Ibison
>
>.
>
|||Shailesh,
please can you try this script instead:
sp_repladdcolumn @.source_object = 'OTHALLOCATION'
, @.column = 'CCICAPPNUM'
, @.typetext = 'NVARCHAR(50) NULL'
, @.publication_to_add = 'GEMREPLGNETINFOTECH'
HTH,
Paul Ibison

How to add new column in MERGE replication

I am using MERGE replication.
Subscription is done @. 17 branch offices @. various locations. It running
successfuly.
Now I want to modify the table and want to add new column to the customer
table.
What should I do. Any changes made @. publisher side, how to apply @.
subscribers side.
Best Regards
Sanjay
Sanjay - please check out sp_repladdcolumn in BOL.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

How to add field to table after replication has started?

I already have Merge replication started between 2
machines and now I want to add a field to a table that is
being used by replication. How can I go about doing this?
Is there a stored procedure to do this?
Thanks in advance,
Jim
Hi,
If you right-click on the publication you can access to all the articles to
alter them, if you go to the filer columns tab you will find the columns
list, you can alter there.
cheers
Salva
"Jim" wrote:

> I already have Merge replication started between 2
> machines and now I want to add a field to a table that is
> being used by replication. How can I go about doing this?
> Is there a stored procedure to do this?
> Thanks in advance,
> Jim
>
|||you can also use sp_repladdcolumn
SQL Server 2005 will allow DDL statements to be replicated.
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
"Jim" <jrathmann@.vtti.vt.edu> wrote in message
news:043101c539df$f3e70120$a601280a@.phx.gbl...
> I already have Merge replication started between 2
> machines and now I want to add a field to a table that is
> being used by replication. How can I go about doing this?
> Is there a stored procedure to do this?
> Thanks in advance,
> Jim

How to Add a Missing Index to a Table in Merge Replication?

One of the table that is in a merge replication somehow is missing an
index. Strangely, only the table in one of the subscriber of the merge
replication is missing the index; another subscriber and the publisher
of the merge replication don't have this problem.

How should I add the missing index back to that table? My understanding
is that making structural change on a table that is in
merge-replication is different from making change on a table that is
not merge-replicated. For example, when we need to add a column into a
table that is being merge-replicated, we must add the column by
changing the attributes in the properties of the published article
(table) instead of simply using CREATE INDEX command. I am wondering
whether there is a similar restriction on adding an index onto a table
that is merge replicated.

I have already added the index back to the table anyway. I am asking
here just in case doing this may get me into a problem later on.
Thanks in advance for any info.

Jay Chan<jaykchan@.hotmail.com> wrote in message
news:1106577312.674228.283880@.z14g2000cwz.googlegr oups.com...
> One of the table that is in a merge replication somehow is missing an
> index. Strangely, only the table in one of the subscriber of the merge
> replication is missing the index; another subscriber and the publisher
> of the merge replication don't have this problem.
> How should I add the missing index back to that table? My understanding
> is that making structural change on a table that is in
> merge-replication is different from making change on a table that is
> not merge-replicated. For example, when we need to add a column into a
> table that is being merge-replicated, we must add the column by
> changing the attributes in the properties of the published article
> (table) instead of simply using CREATE INDEX command. I am wondering
> whether there is a similar restriction on adding an index onto a table
> that is merge replicated.
> I have already added the index back to the table anyway. I am asking
> here just in case doing this may get me into a problem later on.
> Thanks in advance for any info.
> Jay Chan

I seem to remember that MSSQL only replicates indexes as part of an initial
snapshot, and after that they have to be maintained manually, so what you've
done would be fine. But I must admit that I'm not at all sure about the
details, so you might want to post in microsoft.public.sqlserver.replication
and see if you get a better answer.

Simon|||> I seem to remember that MSSQL only replicates indexes as part of an
initial
> snapshot, and after that they have to be maintained manually, so what
you've
> done would be fine. But I must admit that I'm not at all sure about
the
> details, so you might want to post in
microsoft.public.sqlserver.replication
> and see if you get a better answer.

Thanks for the confirmation. In any case, I cannot find a way to add an
index through the attributes of the replication publication anyway. I
am sure I am on the right track.

Jay Chan|||> I seem to remember that MSSQL only replicates indexes as part of an
initial
> snapshot, and after that they have to be maintained manually, so what
you've
> done would be fine. But I must admit that I'm not at all sure about
the
> details, so you might want to post in
microsoft.public.sqlserver.replication
> and see if you get a better answer.

Thanks for the confirmation. In any case, I cannot find a way to add an
index through the attributes of the replication publication anyway. I
am sure I am on the right track.

Jay Chan

How to access toolbar?

I know the ReportViewer Windows form control has a toolbar. Is there any
way to access it directly? I would like to be able to merge it with my
existing toolbar.
TIA,
Mike RodriguezSorry there is no way to extend the existing toolbar. This is a feature
request for a future version however.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Rodriguez" <mike@.nospam.com> wrote in message
news:uhKrZ42%23FHA.3568@.TK2MSFTNGP09.phx.gbl...
>I know the ReportViewer Windows form control has a toolbar. Is there any
>way to access it directly? I would like to be able to merge it with my
>existing toolbar.
> TIA,
> Mike Rodriguez
>