HOWTO: Put Stored Procedures Under Source Control in Visual InterDev

• Microsoft Visual InterDev, version 6.0
• Microsoft SQL Server version 6.5
• Microsoft Visual Studio 6.0

SUMMARY

This article describes how to put SQL Server stored procedures under source control through Visual InterDev 6.0.

MORE INFORMATION

There are two distinct configurations for placing Stored Procedures under source control.

• VSS database is installed on the same machine as SQL Server.



• VSS is installed on a remote machine from SQL Server. For information on using a remote VSS database, please see the following article in the Microsoft Knowledge Base:
  

  Q199204 HOWTO: Put Stored Procedures Under Remote Source Control in Visual InterDev 6.0

Installing Visual SourceSafe onto the SQL Server machine

1. In Data View, right-click the database name and select Add to Source Control.



2. The Enable Source Control dialog box will appear.



3. Type the local path (relative to SQL Server) to the Srcsafe.ini file located on the SQL Server machine.



4. Enter the name of the source control project that you wish to create and click OK.



5. Enter a valid Visual SourceSafe Login ID and Password and then click OK. This user ID and password must be a valid Visual SourceSafe user account. Ensure that the user and password have been entered in the Visual SourceSafe Administration tool for the Visual SourceSafe database on the SQL server.

REFERENCES

Q199204 HOWTO: Put Stored Procedures Under Remote Source Control in Visual InterDev 6.0

Versioning Stored Procedures with Visual Studio 6.0 and SQL Server 7.0

Additional query words: kbDSupport

Keywords          : kbSQLServ kbSSafe kbStoredProc kbVisDBTools kbVisID600 kbGrpASP 
Version           : WINDOWS:6.0; winnt:6.5
Platform          : WINDOWS winnt 
Issue type        : kbhowto 

Last Reviewed: July 23, 1999