I am working with a team of 5 persons. We are using SQL Server as our database. Since long time I want to store the Stored Procedures in SVN so that the versions can be maintained. Is there any tool which can be used as a plugin with SQL Server Management Studio and allows checkin from there.
Sounds like Red Gate's SQL Source Control might be what you're looking for.
It says it connects to "TFS, SVN, SourceGear Vault, Vault Pro, Mercurial, Perforce, Git, and any source control system with a capable command line," and that it "links your databases to your existing source control system straight from SSMS".
I haven't used it personally, but I have used other Red Gate SQL tools, and they have been excellent.
SSDT projects are great for this these days.
You keep all your db & proc & function definitions in script files (which define your model) and within Visual Studio sync the model with your database / publish to a database to update it. As all your object definitions are in script files you can have them under source control using SVN/Hg/whatever.
If I remember correctly (it's been years since I've used SQL Server), you can execute external scripts using
For each stored procedure, I'd write a sql script that removes the current one (if it exists) and creates the new version. Saving these in external
.sql files will allow you to easily commit them to any versioning system. Then, you could write a script using your language of choice to update the database whenever you want.
Obviously you'd want to create a backup of your current database prior to running your script in case all goes to hell.