• You need to remove the alter table statement from the procedure. With it, the procedure can work only the first time that it runs. After the column was added to the table, if you'll try to add a new column that has a name that another column already has, you'll get this error.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/