sql rowcount: merge

Showing posts with label merge. Show all posts

Monday, March 19, 2012

[SQL Server 2000] How to programmatically read Merge Agent properties

Dear all,
I would like to read from SQL Server information that is presented in
Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
Agents (particularly the columns "Subscription" and "Action Time").
Which tables should I read? I checked the tables in msdb and master database
but couldn't find anything suitable. BOL and Google were of no help either.
Thank you in advance for your help.
Best regards,
AndrewTry a profiler trace and examine the source of the executed procs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uBPvoxZAHHA.4024@.TK2MSFTNGP04.phx.gbl...
> Dear all,
> I would like to read from SQL Server information that is presented in
> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
> Agents (particularly the columns "Subscription" and "Action Time").
> Which tables should I read? I checked the tables in msdb and master
> database
> but couldn't find anything suitable. BOL and Google were of no help
> either.
> Thank you in advance for your help.
> Best regards,
> Andrew
>
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
> Try a profiler trace and examine the source of the executed procs.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \ Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
Ok, I've checked, but unfortunately that is an undocumented procedure:
sp_MSenum_replication_agents @.type = 4
(type = 4 stands for merge replication agent)
Thank you for your help.
Best regards,
Andrew|||I took cursory look at the text of that proc and the called proc and it
looks to me like the source of the data is the MSmerge_history table. It's
documented in the Books Online.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Andrew Drake" <andrewdrake@.hotmail.com> wrote in message
news:uizTrebAHHA.4328@.TK2MSFTNGP03.phx.gbl...
> "Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
> news:12D028F8-1237-454D-8387-4A30B283851F@.microsoft.com...
>> Try a profiler trace and examine the source of the executed procs.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Thank you in advance for your help.
>> Best regards,
>> Andrew
> Ok, I've checked, but unfortunately that is an undocumented procedure:
> sp_MSenum_replication_agents @.type = 4
> (type = 4 stands for merge replication agent)
> Thank you for your help.
> Best regards,
> Andrew
>|||"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:CF65CD9F-E7BA-4FAB-AC81-326BD56C2FB7@.microsoft.com...
>I took cursory look at the text of that proc and the called proc and it
>looks to me like the source of the data is the MSmerge_history table. It's
>documented in the Books Online.
[...]
> Dan Guzman
> SQL Server MVP
>> Dear all,
>> I would like to read from SQL Server information that is presented in
>> Enterprise Manager \ <server_name> \ Replication Monitor \ Agents \
>> Merge
>> Agents (particularly the columns "Subscription" and "Action Time").
>> Which tables should I read? I checked the tables in msdb and master
>> database
>> but couldn't find anything suitable. BOL and Google were of no help
>> either.
>> Ok, I've checked, but unfortunately that is an undocumented procedure:
>> sp_MSenum_replication_agents @.type = 4
>> (type = 4 stands for merge replication agent)
Dan,
Thank you for your help!
Best regards,
Andrew

Tuesday, March 6, 2012

[ms sql] How to add new table to merge replication ?

Hi,
How to add new table to merge replication ?

When I do this in Enterpriise Manager i got an error:
Server: Msg 2758, Level 16, State 1, Procedure sp_addmergearticle,
Line 466
RAISERROR could not locate entry for error 20085 in sysmessages.

What is wrong ?

Thank for any help

LukOn Jul 12, 9:49 am, szaki <ljag...@.gmail.comwrote:

Quote:

Originally Posted by

Hi,
How to add new table to merge replication ?
>
When I do this in Enterpriise Manager i got an error:
Server: Msg 2758, Level 16, State 1, Procedure sp_addmergearticle,
Line 466
RAISERROR could not locate entry for error 20085 in sysmessages.
>
What is wrong ?
>
Thank for any help
>
Luk

The handy thing with that procedure is that you can open it up and
look down to the line number, and read the comments, and maybe get an
idea of what the problem is, even if the error message is missing.

Strangely, I can't find it raising 20085 at that line number - on SQL
2000 SP 4. But at that line, there is a check that all articles
contain a column marked with the rowguidcol property (and raising
error 20086). So, is that what's wrong with your table?

Damien

Monday, February 13, 2012

[2005 beta 2] merge replication sql server to sql server mobile

Quote:

Originally posted by dieweb
Hello,
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
################################################## ######################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
################################################## ######################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
Diemo

[2005 beta 2] merge replication sql server to sql server mobile

Hello,
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
########################################
################################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
########################################
################################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
DiemoYou will probably have better luck in the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
"dieweb" <dawinci@.wh20.tu-dresden.de> wrote in message
news:30chlqF2v7b8kU1@.uni-berlin.de...
> Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005 supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database, but
> when i try to subscribe from my mobile database, i get the following
error:
> ########################################
################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for this
> publication. If this snapshot is currently being generated, wait for the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################
################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in the
> replication folder.
> And I don't know whats the right argument for "distributor" to run the
> snapshot agent manually (snapshot.exe). I thought its the server, but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something like
> this to work and can give a short howto?
> Best regards
> Diemo|||Hi Diemo
I am facing the same problem...check the newsgroup and could not find
any answers. Could u help me. Many thanks.
Regards
Danny Cheah
Malaysia.
dieweb wrote:
> *Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005
> supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database,
> but
> when i try to subscribe from my mobile database, i get the following
> error:
> ########################################
################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for
> this
> publication. If this snapshot is currently being generated, wait for
> the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################
################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in
> the
> replication folder.
> And I don't know whats the right argument for "distributor" to run
> the
> snapshot agent manually (snapshot.exe). I thought its the server,
> but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something
> like
> this to work and can give a short howto?
> Best regards
> Diemo *
DannyCheah
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1239516.html

[2005 beta 2] merge replication sql server to sql server mobile

Hello,
the main subject of my problem is, that i want to create a mobile
database from a server database on the server. Sql server 2005 supports
this, but it doesn't work.
I created a publication for merge replication in my server database, but
when i try to subscribe from my mobile database, i get the following error:
########################################################################
- Beginning Synchronization (Success)
- Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed.
HRESULT 0x80045003 (29045)
The initial snapshot for publication 'PUBLICATIONNAME' is not yet
available. Start the Snapshot Agent to generate the snapshot for this
publication. If this snapshot is currently being generated, wait for the
process to complete and restart the synchronization.
HRESULT 0x80045003 (0)
The operation could not be completed.
- Finalizing Synchronization (Stopped)
- Saving Subscription Properties (Stopped)
########################################################################
But I am not able to generate a snapshot. When I use the "Generate
snapshot" option in the context menu of my publication, it only
generates a .bnc file of one of the tables i want to replicate in the
replication folder.
And I don't know whats the right argument for "distributor" to run the
snapshot agent manually (snapshot.exe). I thought its the server, but
doesn't work.
Has anybody an idea, wheres my failure? Does anybody get something like
this to work and can give a short howto?
Best regards
DiemoYou will probably have better luck in the beta newsgroups.
http://www.aspfaq.com/sql2005/show.asp?id=1
"dieweb" <dawinci@.wh20.tu-dresden.de> wrote in message
news:30chlqF2v7b8kU1@.uni-berlin.de...
> Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 2005 supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database, but
> when i try to subscribe from my mobile database, i get the following
error:
> ########################################################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot for this
> publication. If this snapshot is currently being generated, wait for the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate in the
> replication folder.
> And I don't know whats the right argument for "distributor" to run the
> snapshot agent manually (snapshot.exe). I thought its the server, but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get something like
> this to work and can give a short howto?
> Best regards
> Diemo|||Hi Diemo
I am facing the same problem...check the newsgroup and could not fin
any answers. Could u help me. Many thanks.
Regards
Danny Cheah
Malaysia.
dieweb wrote:
> *Hello,
> the main subject of my problem is, that i want to create a mobile
> database from a server database on the server. Sql server 200
> supports
> this, but it doesn't work.
> I created a publication for merge replication in my server database
> but
> when i try to subscribe from my mobile database, i get the followin
> error:
> ########################################################################
> - Beginning Synchronization (Success)
> - Synchronizing Data (100%) (Error)
> Messages
> Initializing SQL Server Reconciler has failed.
> HRESULT 0x80045003 (29045)
> The initial snapshot for publication 'PUBLICATIONNAME' is not yet
> available. Start the Snapshot Agent to generate the snapshot fo
> this
> publication. If this snapshot is currently being generated, wait fo
> the
> process to complete and restart the synchronization.
> HRESULT 0x80045003 (0)
> The operation could not be completed.
>
> - Finalizing Synchronization (Stopped)
> - Saving Subscription Properties (Stopped)
> ########################################################################
> But I am not able to generate a snapshot. When I use the "Generate
> snapshot" option in the context menu of my publication, it only
> generates a .bnc file of one of the tables i want to replicate i
> the
> replication folder.
> And I don't know whats the right argument for "distributor" to ru
> the
> snapshot agent manually (snapshot.exe). I thought its the server
> but
> doesn't work.
> Has anybody an idea, wheres my failure? Does anybody get somethin
> like
> this to work and can give a short howto?
> Best regards
> Diemo
-
DannyChea
----
Posted via http://www.mcse.m
----
View this thread: http://www.mcse.ms/message1239516.htm

Saturday, February 11, 2012

@max_concurrent_merge

I have a merge publication (dynamically filtered). Subscriptions are
all anonymous (all run at the subscriber) and run continuously.
What effect does the publication option @.max_concurrent_merge have on
a replication topology such as this? Also known as the "Publication
Properties | Subscriptions tab | "Limit the number of concurrent merge
processes to the following" setting . . .
I noticed in a test environment when I set it to 1 my 2 anonymous
subscribers are still able to connect and reach "no data to be
merged". . . does setting this physically limit the number of "merge
activity" or the number of "merge agent connections" or something
else? I believe my testing shows it doens't limit the connections, but
maybe it does something w/ the "merge activity" under the hood?
Any help is greatly appreciated . . .
Matt
It limits the number of simultaneous merge agents that can run. The default
for this is 10, so if you have 20 subscribers running continuously, only 10
of them would be running simultaneously and the rest would be queued.
For 2 subscribers you should not have to worry about it.
Please refer to this link for a more indepth discussion of this.
http://www.microsoft.com/technet/pro.../mergperf.mspx
"Matt" <la_la_looey@.yahoo.com> wrote in message
news:a0313d3.0404210946.4e767ee9@.posting.google.co m...
> I have a merge publication (dynamically filtered). Subscriptions are
> all anonymous (all run at the subscriber) and run continuously.
> What effect does the publication option @.max_concurrent_merge have on
> a replication topology such as this? Also known as the "Publication
> Properties | Subscriptions tab | "Limit the number of concurrent merge
> processes to the following" setting . . .
> I noticed in a test environment when I set it to 1 my 2 anonymous
> subscribers are still able to connect and reach "no data to be
> merged". . . does setting this physically limit the number of "merge
> activity" or the number of "merge agent connections" or something
> else? I believe my testing shows it doens't limit the connections, but
> maybe it does something w/ the "merge activity" under the hood?
> Any help is greatly appreciated . . .
> Matt
|||2 subscribers was my test lab . . . I actually have over 100.
I believe after extended testing, I see this setting simply controls
the number of connections . . . so, if you have your agent set to run
continuously, other agents would "starve."
"Hilary Cotter" <hilaryk@.att.net> wrote in message news:<#HF4BTBKEHA.2556@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
> It limits the number of simultaneous merge agents that can run. The default
> for this is 10, so if you have 20 subscribers running continuously, only 10
> of them would be running simultaneously and the rest would be queued.
> For 2 subscribers you should not have to worry about it.
> Please refer to this link for a more indepth discussion of this.
> http://www.microsoft.com/technet/pro.../mergperf.mspx
>
> "Matt" <la_la_looey@.yahoo.com> wrote in message
> news:a0313d3.0404210946.4e767ee9@.posting.google.co m...
|||not so, they are queued until the others finished. sort of like a round
robin. Check out the link for more info.
"Matt" <la_la_looey@.yahoo.com> wrote in message
news:a0313d3.0404220441.15777f5c@.posting.google.co m...
> 2 subscribers was my test lab . . . I actually have over 100.
> I believe after extended testing, I see this setting simply controls
> the number of connections . . . so, if you have your agent set to run
> continuously, other agents would "starve."
>
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
news:<#HF4BTBKEHA.2556@.TK2MSFTNGP11.phx.gbl>...[vbcol=seagreen]
default[vbcol=seagreen]
10[vbcol=seagreen]
http://www.microsoft.com/technet/pro.../mergperf.mspx[vbcol=seagreen]

@force_reinit_subscription

Hi,

If I add or remove a merge article from a publication and I specify the @.force_reinit_subscription = 1, will this force a new snapshot to be sent to all subscribers? If it does, will it apply the who snapshot as it did when the subscription was created or is it clever enough to work out what bits are different?

Thanks for your help

Graham

if you drop an article, and you force reinit and snapshot generation, depending on exactly what needs to be generated, you may be required to create a new snapshot (and dynamic snapshot), and apply new snapshot. i.e. if you drop a static article (not filtered, nor not participating in any joins), you may not need to generate a snapshot. But if you the article is a filtered article, or participates in a join, the snapshot may need to be reapplied.

So yes, it's clever :)

Monday, March 19, 2012

[SQL Server 2000] How to programmatically read Merge Agent properties

[SQL Server 2000] How to programmatically read Merge Agent properties

Tuesday, March 6, 2012

[ms sql] How to add new table to merge replication ?

Monday, February 13, 2012

[2005 beta 2] merge replication sql server to sql server mobile

[2005 beta 2] merge replication sql server to sql server mobile

[2005 beta 2] merge replication sql server to sql server mobile

[2005 beta 2] merge replication sql server to sql server mobile

Saturday, February 11, 2012

@max_concurrent_merge

@force_reinit_subscription

sql rowcount

Blog Archive

About Me