| Author |
what is sp_MScheckexistsgeneration?
|
|
|
| declare @P1 int
set @P1=121
exec sp_MScheckexistsgene
ration '633C29DB-678E-46C0-AD3A-E1609F33EC8D', @P1
output
select @P1
We are testing merge replication for a database where the database can be
accessed using a web-based application. We noticed that the above procedure
is getting executed frequently.
What is the purpose of this procedure . Why it should run very frequently.
rgds,
Soura
| |
| Hilary Cotter 2006-01-26, 8:23 pm |
| Its checking to see what was the last generation sent by the publisher to
the subscriber.
--
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
"SouRa" <SouRa@discussions.microsoft.com> wrote in message
news:E56C9220-BF3B-49E2-A6FA- 7FF5FEBB4971@microso
ft.com...
> declare @P1 int
> set @P1=121
> exec sp_MScheckexistsgene
ration '633C29DB-678E-46C0-AD3A-E1609F33EC8D',
> @P1
> output
> select @P1
>
> We are testing merge replication for a database where the database can be
> accessed using a web-based application. We noticed that the above
> procedure
> is getting executed frequently.
>
> What is the purpose of this procedure . Why it should run very frequently.
>
> rgds,
> Soura
>
| |
| Michael Hotek 2006-01-27, 1:23 pm |
| It more generically checks the generations sent and received. It has to do
this at both the publisher and the subscriber. This is the proc which
controls the calculation algorithm used by the merge engine to determine
what data to send between publisher and subscriber.
--
Mike
http://www. solidqualitylearning
.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23LVXSeuIGHA.3100@tk2msftngp13.phx.gbl...
> Its checking to see what was the last generation sent by the publisher to
> the subscriber.
>
> --
> 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
>
> "SouRa" <SouRa@discussions.microsoft.com> wrote in message
> news:E56C9220-BF3B-49E2-A6FA- 7FF5FEBB4971@microso
ft.com...
>
>
|
|
|
|