>>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.
If it's not broken, fix it until it is.
My Blog