How to use SQL Server Management Studio to save existing SP to source safe?

Wiith SQL Server Management Studio(SQL Server 2005 tools), you can create a project and solution and connect to SourceSafe, then create SQL scripts.These scripts will be able to be checked in/out SourceSafe.

Question is: For existing SQL Server 2000 database, how can I add all existing Stored Procedure to this solution/project and then be able to use sourcesafe to maintain the SP code history?

What I would do is create a database solution/project for each instance in VS2005, script out the objects from the database server and add them to the solution, add the solution to your source control.

How to use SQL Server Management Studio to save existing SP to source safe?

Wiith SQL Server Management Studio(SQL Server 2005 tools), you can create a project and solution and connect to SourceSafe, then create SQL scripts.These scripts will be able to be checked in/out SourceSafe.

Question is: For existing SQL Server 2000 database, how can I add all existing Stored Procedure to this solution/project and then be able to use sourcesafe to maintain the SP code history?

What I would do is create a database solution/project for each instance in VS2005, script out the objects from the database server and add them to the solution, add the solution to your source control.