List of synchs?

Which query gives me the no of synchs in Merge replication? If a user is
synchronizing 10 times I need the information of all the 10 synchs.
I am using the following query,
SELECT a.subscriber_db
,runstatus
,start_time
,end_time
,duration [Synch Duration]
FROM dbo.MSmerge_sessions s
LEFT OUTER JOIN MSmerge_agents a
ON a.id=s.agent_id
This query is not giving me consistent result. Every time I run this query
I get some of the records missing.
Can someone put some light?
This should work. Is it possible that there are no rows synchronized during
these missing syncs?
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
"Ravi Lobo" <RaviLobo@.discussions.microsoft.com> wrote in message
news:07DC40EB-9386-4A41-82B8-027D80FDA4F9@.microsoft.com...
> Which query gives me the no of synchs in Merge replication? If a user is
> synchronizing 10 times I need the information of all the 10 synchs.
> I am using the following query,
> SELECT a.subscriber_db
> ,runstatus
> ,start_time
> ,end_time
> ,duration [Synch Duration]
> FROM dbo.MSmerge_sessions s
> LEFT OUTER JOIN MSmerge_agents a
> ON a.id=s.agent_id
> This query is not giving me consistent result. Every time I run this
> query
> I get some of the records missing.
> Can someone put some light?
>

List of Merge Article

I know transactional replication keep all articles in sysarticle system
table. Is there any other table or views for merge articles.
TIA
Thanks ,
I found the table name sysmergearticles.
"Sandeep Shankar" <sandeeps@.dntg.net> wrote in message
news:%236KR54AxHHA.1484@.TK2MSFTNGP06.phx.gbl...
> I know transactional replication keep all articles in sysarticle system
> table. Is there any other table or views for merge articles.
> TIA
>
|||Also have a look at sp_MShelpmergearticles.
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
"Sandeep Shankar" <sandeeps@.dntg.net> wrote in message
news:%236KR54AxHHA.1484@.TK2MSFTNGP06.phx.gbl...
>I know transactional replication keep all articles in sysarticle system
> table. Is there any other table or views for merge articles.
> TIA
>

list existing replication's settings

Hi experts,
I wish to document the replication settings on our
environment, is there a good way to list the settings on
the system ?
regards,
Diana.
Diana,
there are loads of sps to help with documentation:
sp_helpdistpublisher
sp_helpdistributor
sp_helppublication
sp_helpsubscription
to name but a few. Many of them take parameters, so you can't run them
without first configuring.
I personally do things in a less sophisticated way - I right-click the
replication folder and select "Generate SQL script..." which is then placed
in Sourcesafe.
You could also do this in SQLDMO, but IMO the simplest and quickest way
would be to have EM create the script as above.
HTH,
Paul Ibison
|||sp_helppublication provides much of the information you are looking for.
I also find it helpful to script out my replication jobs. Here is an example
of such a script.
set objServer=CreateObject("SQLDMO.SQLServer")
objServer.LoginSecure=True
objServer.Connect "Publisher"
objServer.Replication.Script 1024,"c:\sqlout.sql"
set objServer=Nothing
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Diana" <yuendiana@.sinaman.com> wrote in message
news:261301c47dfb$d68d8a40$a301280a@.phx.gbl...
> Hi experts,
> I wish to document the replication settings on our
> environment, is there a good way to list the settings on
> the system ?
> regards,
> Diana.

Lisence for replication

Hello there
I have two servers who needs to be updated From master to slave.
For this i need to use the replication
I've heared that i need Enterprise on both sides and it coast approx 19000$
Do i need them on both sides? or i can use the standart
' 03-5611606
' 050-7709399
: roy@.atidsm.co.il
I think you are thinking about Log Shipping. There is a wizard which allows
you to do this in the Enterprise Edition, but you are free to roll your own.
Replication is a free component which ships in most versions of SQL Server.
In most other RDBMS's it is another component which you have to pay for.
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
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%231zdmsWCGHA.3920@.tk2msftngp13.phx.gbl...
> Hello there
> I have two servers who needs to be updated From master to slave.
> For this i need to use the replication
> I've heared that i need Enterprise on both sides and it coast approx
> 19000$
> Do i need them on both sides? or i can use the standart
> --
>
> ' 03-5611606
> ' 050-7709399
> : roy@.atidsm.co.il
>
|||Whell Hilary
If on my SQL server, which is standart edition I can use replication, is
that means that it is leagal?
and if not. and from Enterprise edition I can push replication to subscriber
who has standart edition. does the subscriber have to be enterprise edition?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:#UjdR8WCGHA.1312@.TK2MSFTNGP09.phx.gbl...
> I think you are thinking about Log Shipping. There is a wizard which
allows
> you to do this in the Enterprise Edition, but you are free to roll your
own.
> Replication is a free component which ships in most versions of SQL
Server.
> In most other RDBMS's it is another component which you have to pay for.
> --
> 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
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%231zdmsWCGHA.3920@.tk2msftngp13.phx.gbl...
>
|||As long as you have the per processor license or you have CALs in place this
should be ok. You do not need a special license to connect from Standard to
Enterprise.
Does this answer your question?
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
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:e8$1KcZCGHA.4040@.TK2MSFTNGP12.phx.gbl...
> Whell Hilary
> If on my SQL server, which is standart edition I can use replication, is
> that means that it is leagal?
> and if not. and from Enterprise edition I can push replication to
> subscriber
> who has standart edition. does the subscriber have to be enterprise
> edition?
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:#UjdR8WCGHA.1312@.TK2MSFTNGP09.phx.gbl...
> allows
> own.
> Server.
>