Creating addin for making db templates

Question

I need to make an addin using C# for creating templete SP's in a sqlserver 2000 DB. So as soon as I select a DBtable templete sp's for create,delete,update and read should be created. Any pointers?