Many users that are using automatic workflows in Windows SharePoint Services 3.0 (WSS) have experienced problems with the workflows not running automatically after applying Service Pack 1 for WSS. According to Microsoft this is a feature because of changes to security. Anyway, Microsoft have had a KB article out (see KB947284) for a possible workaround on this since February but many people including myself has found this KB article to be useless as the problem remain after performing the steps mentioned in the article.
Anyway, after working with Microsoft Product Support Services on this issue for some weeks it seems that Microsoft soon will be done with a hotfix that once and for all will resolve the automatic workflow bug. I’m holding my thumbs!