HOWTO: Put Stored Procedures Under Source Control in Visual InterDev

ID: Q201240


The information in this article applies to:


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.

Installing Visual SourceSafe onto the SQL Server machine

On the client that is running Visual InterDev follow these steps:
  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.


Stored procedures successfully placed under source control will display a lock icon.


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