hi Stefan,

Thanks for your reply, it was much helpful for us!

Now we found in SQL's event log that the following statement is much frequen
t:

exec sp_executesql N'Select NodeGUID, ParentGUID, Reason, LastChangeTime,
CommitTime, Type, IsShortcut from ChangeTable where CommitTime > @P1 order b
y
CommitTime desc', N'@P1 datetime', '06  6 2007  3:02:44:293AM'

I wonder which program trigers this statement? why it is so frequent?

Thanks in advance

zch

[ Post a follow-up to this message ]

Hi,

this is MCMS.
It checks if something has changed to allow MCMS to update it's caches.
Relevant especially to sync multiple servers in a farm.

Cheers,
Stefan

"zch" <zch@discussions.microsoft.com> wrote in message
news:116BD230-FBCD-464B-95AB-9A7AF490BB42@microsoft.com...
> hi Stefan,
>
> Thanks for your reply, it was much helpful for us!
>
> Now we found in SQL's event log that the following statement is much
> frequent:
>
> exec sp_executesql N'Select NodeGUID, ParentGUID, Reason, LastChangeTime,
> CommitTime, Type, IsShortcut from ChangeTable where CommitTime > @P1 order
> by
> CommitTime desc', N'@P1 datetime', '06  6 2007  3:02:44:293AM'
>
> I wonder which program trigers this statement? why it is so frequent?
>
> Thanks in advance
>
> zch

[ Post a follow-up to this message ]