>>>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...
>>
>>We maintain 1 file/SP. Each SP is under source control and versioned like any other project artifact.
>
>Which VS software you're using? Does it integrate natively with SQL Server?
>
>We're not using actual versioning software here :( And nothing for MS SQL.
>We use baazar command line (installed by my colleague) as the versioning for working project. Can not say I'm happy with it.

We use Visual SourceSafe. It is not integrated with SQL Server. We manually add the script files. All SPs, table structure mods, indexes, basically anything that can be scripted is under source control.