Hi,
I have to manage 410 stored procedures and sometimes I have to change
table structure schema.

I've created a specific stored procedure which is recompiled all of them.

But, all dependant stored procedure whom the basic tables have been changed
don't work and have to be drop and create again.
I understand that is due to the tableID is not updated within the query plan of each stored procedure.
How to avoid that ?
Should I create an extracting script (by SQL-DMO) which will drop and recreate all stored procedures.

Thanks,
Herve Meftah
hmeftah@aol.com