see my response above. I wrote the program for one installation. There I had access to the db, and was able to create the storedproc in the database. Now I am using the same program for another installation... in this case it is not yet clear if I will have access to the db to create a storedproc in it. Hence, I am trying to redo the script with all the SQL in the script itself.