HELP REQUIRED FOR SP..........

[somaiyatushar11]

i have a simple SP which gives me information from 5 different tables... This SP compiles successfully... But sometimes SP gets dropped automatically.. or i don't know what happens but i have to recompile it and then execute it...this happens very regularly....

i don't know if anything is wrong with the SP or server settings or what.. because other 40 SPs run fine. i have this peculier problem with this SP only...

if anybody knows why this happens or / and how to solve it then please let me know. if required i can send the SP code to you....

 

[rao1soft]

If any of the tables that are used by this SP is dropped and recreated, you will have to recompile the SP. Is that the case?