Microsoft Content Management Server - about mcms 2002 publish(6)

This is Interesting: Free IT Magazines  
Home > Archive > Microsoft Content Management Server > June 2007 > about mcms 2002 publish(6)





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author about mcms 2002 publish(6)
zch

2007-06-06, 7:17 am

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
Stefan Goßner [MSFT]

2007-06-06, 7:17 am

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



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com