Michael
It has something to do with when a field is added or modfied from one of the tables in the stored procedure. I apoligize because I have never written the error down so I can't quote what it says. But basicly it says that the underling table has been changed since the query started (I'm assuming this means since it was compiled) and then returns me a -1. To fix it, all I have to do is add a blank line in the EM and save the stored procedure and it works (I'm assuming that when I save it, it automaticly recompiles).
Thanks
Kirk