Also, do you have delay validation turned on?
If you search yahoo on your error you'll find plenty of discussions on it.
Maybe you'll find the answer there too.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant