Hi All,

I just had a really bizzare issue with MCMS & SQL.

Environment
- WinXP + MCMS Developer Edition
- Win2k3 + SQL Std Edition

When I chose to compare 2 revisions of a posting ; and one of the revisions
was after a certain date (I guess I changed the template after that date)
the page would freeze; I did an iisreset etc. and this didn't resolve the
issue.

I then noticed the SQL Server was at 100% CPU.

Once I rebooted the SQL Server the revision comparer worked perfectly...

I didn't have time to profile the database so I couldn't check for locks.

I have never experienced this before but it was plenty strange...Any ideas?
--
 ________________________________________


Angus Logan  (MCAD/MCDBA/MCP/MVP for MCMS)
Product Specialist
Microsoft Application Solutions
Data#3 Limited
E angus_logan@data3.com.au
BLOG www.anguslogan.com
 ________________________________________

[ Post a follow-up to this message ]