<tedcorpus@hotmail.com> wrote in message
news:%23F7cc61eFHA.412@tk2msftngp13.phx.gbl...
> Is there any way to find out a subscriber's assigned identity range (at
the
> publisher)?
> It would be helpful to have an idea where a row was added from its
identity
> value.
>
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:ehDGtl7eFHA.2076@TK2MSFTNGP15.phx.gbl...
> In the distribution database, MSrepl_identity_range holds the next ranges,
> so You'll have to work with the metadata tables on the subscribers for
> this:
>
> You could use this type of query:
> SELECT sysobjects.name AS TableName, *
> FROM MSrepl_identity_range INNER JOIN
> sysobjects ON MSrepl_identity_range.objid =
> sysobjects.id
>
> The data from each subscriber could be amalgamated at the publisher using
> linked servers,
>
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

"TCorp" <tcorpus@hotmail.com> wrote in message
news:eg1MgYagFHA.2548@TK2MSFTNGP10.phx.gbl...
> Thanks!
> So I could compare max_identity/current_max columns across servers
> (accounting for the range value). But linking the servers just for this
> purpose might be more administration work than benefit at this point.
>
> "Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
> news:ehDGtl7eFHA.2076@TK2MSFTNGP15.phx.gbl...
> > In the distribution database, MSrepl_identity_range holds the next
ranges,
> > so You'll have to work with the metadata tables on the subscribers for
> > this:
> >
> > You could use this type of query:
> > SELECT sysobjects.name AS TableName, *
> > FROM MSrepl_identity_range INNER JOIN
> > sysobjects ON MSrepl_identity_range.objid =
> > sysobjects.id
> >
> > The data from each subscriber could be amalgamated at the publisher
using
> > linked servers,
> >
> > Rgds,
> > Paul Ibison SQL Server MVP, www.replicationanswers.com
> > (recommended sql server 2000 replication book:
> > http://www.nwsu.com/0974973602p.html)
> >
>
>