STSADM custom commands

Gary Lapointe has published custom stsadm extension with some very useful migration commands (among many others): http://stsadm.blogspot.com/2007/08/stsadm-commands_09.html

Some part of your SQL statement is nested too deeply...

I ran into this error after testing a 'on change' workflow that was itself updating the item it was running on (which of course creates a loop):

"Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries."

turns out that this is caused by a bug in SharePoint in combination with too many items returned in a CAML query from the workflow history list.

this post explains it nicely: http://blogs.blackmarble.co.uk/blogs/rhepworth/archive/2008/07/03/workflow-history-and-sql-error.aspx