Showing posts with label replicated. Show all posts
Showing posts with label replicated. Show all posts

Monday, March 26, 2012

Is there a doc listing the limitations of Replication under 2005?

I am looking for a doc (BOL, etc.) which enumerates things like limits on the number of columns which can be replicated, or limits on the size of the row. BOL covers this for 2000, but I can not find it in BOL 2005.

Thanks.

Please see the following topic "Maximum Capacity Specifications for SQL Server 2005" in BOL: http://msdn2.microsoft.com/en-us/library/ms143432.aspx

Peng

Friday, March 9, 2012

is sp_replcounters accurate ?

How does sp_replcounters keep itself updated ? I cant seem to get it
refreshing. The replicated transactions for a database is around 8 and is
not decreasing althought the log reader agent is running.
Do you use it for accurate info to track any issues between the publisher
and the distribution database ?
It is somewhat accurate if your agents are running continuously. It uses an
extended stored procedure, so its hidden as to how it actually works.
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
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uvRnZNdWFHA.2692@.TK2MSFTNGP15.phx.gbl...
> How does sp_replcounters keep itself updated ? I cant seem to get it
> refreshing. The replicated transactions for a database is around 8 and is
> not decreasing althought the log reader agent is running.
> Do you use it for accurate info to track any issues between the publisher
> and the distribution database ?
>