>Hi everybody,
>
>What is the simplest way to move several SPs (I have create scripts (with DROP) for all of them as different files) to production?
>
>Thanks a lot in advance.
>
>One way would be to put all the scripts into one file, another would be to execute in a batch. The second way was discussed here before, but I don't recall right now...


I use a SQL Compare from Red-Gate.