rowguid ?

Hi,
I tried to make a replication between two databases, a merge
replication...
But at the end, when the replication agents started, I found lots of errors
that tells me
that it don't knows who is the column 'rowguid'. This column was added only
on the publisher.
Can somebosy tell me what is wrong? what is the right solution?
Thank you in advance,
Alex
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
".:alex:." <alex_77ro@.yahoo.com> wrote in message
news:Of2SSEjgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I tried to make a replication between two databases, a merge
> replication...
> But at the end, when the replication agents started, I found lots of
errors
> that tells me
> that it don't knows who is the column 'rowguid'. This column was added
only
> on the publisher.
> Can somebosy tell me what is wrong? what is the right solution?
> Thank you in advance,
> Alex
>
>
|||your's book title is:
"A Guide to SQL Server 2000 Transactional and Snapshot Replication"
but I need info about merge replication. In fact a little help, I no need to
learn the replication mechanism , etc... because isn't my job. I need a
little info
like I found here:
http://www.databasejournal.com/featu...le.php/1438231
Thank you for your attention,
Alex
PS: I'm mechanical engineering too ;)
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OFeQ5WjgFHA.1252@.TK2MSFTNGP09.phx.gbl...
>
> --
> 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
> ".:alex:." <alex_77ro@.yahoo.com> wrote in message
> news:Of2SSEjgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> errors
> only
>
|||Can you post the error number, and possibly the exact message.
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
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OFeQ5WjgFHA.1252@.TK2MSFTNGP09.phx.gbl...
>
> --
> 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
> ".:alex:." <alex_77ro@.yahoo.com> wrote in message
> news:Of2SSEjgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> errors
> only
>
|||I don't know a number or the exact message, because I disabled the
publisher and I cannot reproduce the scenario from my station (in this case
the test computer) because I cannot start de SQLServerAgent.
I will research ...
Thank you anyway
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OMiaskjgFHA.1948@.TK2MSFTNGP12.phx.gbl...
> Can you post the error number, and possibly the exact message.
> --
> 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
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:OFeQ5WjgFHA.1252@.TK2MSFTNGP09.phx.gbl...
>
sql

Rouge Agents

How do I go about removing some rouge agents? Specifically, I have a
couple of snapshot agents for publications that do not exist. They
have the damn red 'X' on them and when I try to start the agent, I get
the error...'Error 14262: The specified @.job_id
('...bla...bla...bla...') does not exist.
TIA,
Larry...
do you mean rouge or rogue? Disconnect from EM, reconnect. Normally
this fixes this problem.
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
|||Hillary,
Thanks for the spell check.
My problem is that the subscriptions are gone, but the snap shot agents
are still there. Is there a table that I can go into and delete/remove
them? Will I need to delete any jobs any where?
Larry...
|||Larry,
It depends on where you are seeing them! Generally you see these "ghosted"
agents when entries get stuck in the agent_status table in Tempdb.
Restarting SQL SHOULD clear that up...
However, you could check the following:
distribution..ms*_agents
and tempdb..MS_replication_agent_status
Of course the obligatory disclaimer: Microsoft does not support, nor
encourage editing these system tables. Doing so may cause replication to
become damaged beyond repair. Do so at your own risk.
Donna Lambert
"LPR-3rd" wrote:

> Hillary,
> Thanks for the spell check.
> My problem is that the subscriptions are gone, but the snap shot agents
> are still there. Is there a table that I can go into and delete/remove
> them? Will I need to delete any jobs any where?
> Larry...
>