I have a SQL Server 2000 database by design with 50+ tables by state. Example: [login to view URL], [login to view URL], [login to view URL], [login to view URL], etc... I need to add two more fields to all the tables. Since the tables have the same structure and similar naming convention. I would like a store procedure that scans all tables (by reading the tables view) in the database with name [[login to view URL]; where xxxx=owner] and run an alter statement adding the two new fields at the end of each table. I just need a prototype to show this works and I will apply the stored procedure in my production environment.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows NT, 2000,XP: SQLServer 97 or 2000