>I have a stored procedure that after a table is modified (doesn't happen all that often), this stored procedure no longer works. I have to open up the stored procedure in EM and I just add a blank line and save it, then it works. I didn't know if before calling this stored procedure, if I issued a SQLPREPARE(gnHandle, 'mystoredprocedure') if it would recompile it then.
I haven't used it before, but have you tried the sp_recompile system stored procedure or use the WITH RECOMPILE option when you call your sproc?
Chris McCandless
Red Sky Software