Showing posts with label limit. Show all posts
Showing posts with label limit. Show all posts

Saturday, February 25, 2012

Replication Limiting Subscribers

How can we limit the number of anonymous merge subscribtions to a
given publication? Can we limit it by machine MAC address?
(Bump!)
Guys I really need an answer to this question.
How can we limit the number of anonymous merge subscribtions to a
given publication (assuming i can have only one sql account per
publication and no NT authentication)?
The problem with giving a set of sql accounts is that they can be
reused.
Can we limit it by machine MAC address?
Thanks,
Hananiel
hananiel@.yahoo.com (Hananiel) wrote in message news:<e338e321.0410130607.37e214d5@.posting.google. com>...
> How can we limit the number of anonymous merge subscribtions to a
> given publication? Can we limit it by machine MAC address?

Replication Limit?

Is there a limit to how many databases can be replicated in a MSDE 2000
environment? We have several servers with several replicated MSDE 2000
databases. It seems that we are hitting a limit because we cannot replicate
any more databases. Any ideas?
What kind of problems are you having?
Are you not able to setup anymore databases for replication or does the
replication just fail.
How many databases are you replicating on each server?
Have you off-loaded the distributor database to another server or does each
server act as its own distributor?
Jim
"VB Programmer" <growNO-SPAM@.go-intech.com> wrote in message
news:euv7a7jHEHA.2876@.TK2MSFTNGP09.phx.gbl...
> Is there a limit to how many databases can be replicated in a MSDE 2000
> environment? We have several servers with several replicated MSDE 2000
> databases. It seems that we are hitting a limit because we cannot
replicate
> any more databases. Any ideas?
>

Replication limit?

Is there a limit to how many databases can be replicated in a MSDE 2000
environment? We have several servers with several replicated MSDE 2000
databases. It seems that we are hitting a limit because we cannot replicate
any more databases. Any ideas?
there is a connection limit. MSDE is throttled to 8 simultaneous
connections. This might be what you are bumping into.
"VB Programmer" <growNO-SPAM@.go-intech.com> wrote in message
news:es6cv7jHEHA.3576@.TK2MSFTNGP10.phx.gbl...
> Is there a limit to how many databases can be replicated in a MSDE 2000
> environment? We have several servers with several replicated MSDE 2000
> databases. It seems that we are hitting a limit because we cannot
replicate
> any more databases. Any ideas?
>
|||Any way around that?
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:%23GwkWlkHEHA.3528@.TK2MSFTNGP09.phx.gbl...
> there is a connection limit. MSDE is throttled to 8 simultaneous
> connections. This might be what you are bumping into.
> "VB Programmer" <growNO-SPAM@.go-intech.com> wrote in message
> news:es6cv7jHEHA.3576@.TK2MSFTNGP10.phx.gbl...
> replicate
>
|||As Hilary mentionned, the limit is 8 simultaneous connections, and that
means CONCURRENT connections. So, by implementing schedules so that the
connections do not occur at the same time, I suppose you might work your way
out.
Raj Moloye