Patent ID: 7979393

Claim:
A computer program product for identifying changes to a database schema in a peer-to-peer environment and modifying database procedures to remain consistent with the changed schema, the computer program product comprising one or more computer readable storage media having encoded thereon computer executable instructions which, when executed upon one or more computer processors, perform the following: identifying changes to a database schema, the changes occurring on at least one node of a plurality of nodes comprising the database; a first node of the plurality of nodes broadcasting a request to a plurality of peer nodes to change stored procedures which depend upon the previous unchanged database schema for proper operation; identifying one or more procedures which depend upon the previous unchanged database schema for proper operation, each of the one or more stored procedures being stored upon one or more of the plurality of nodes; modifying each of the identified one or more procedures to remove the dependency upon the previous database schema so that the changed one or more procedures are consistent with and will properly operate with the changed database schema.