>>>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?

You can create projects in Sql Server Management Studio and should be able to use any MSSCCI (Visual Source Safe, Sourcegear Vault, Subversion if using one of the many MSSCCI compliant add-ons for it, etc...) enabled source version control client. We use vault and have had excellent success with it.

We also have extensive experience with using Visual Studio Team Edition for Database Professionals (aka DataDude) which allows us to use the more extensively featured Vault VSIP client from inside Visual Studio 2005 and 2008.

>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.