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.
Thanks
Kirk