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

ID: Q199204

The information in this article applies to:

Microsoft Visual InterDev, version 6.0

SUMMARY

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

MORE INFORMATION

There are two distinct configurations for placing stored procedures under source control.

Visual SourceSafe database is installed on the same machine as SQL Server.

Visual SourceSafe is installed on a remote machine from SQL Server.

Install the Visual SourceSafe client components on the SQL Server machine. You can do this by running Netsetup.exe from the directory of the machine that has the Visual SourceSafe database installed on it.

Change the MSSQLServer service to run under a user acount that has access to the remote machine. SQL Server uses the this account to logon to the remote server in order to check files in and out of Visual SourceSafe.

On the client that is running Visual InterDev follow these steps:

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

The Enable Source Control dialog box will appear.

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

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

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 database on the remote machine.

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

Additional query words: kbDSupport

Keywords : kbSSafe600 kbStoredProc kbVisID600 kbGrpASP
Version : WINDOWS:6.0
Platform : WINDOWS
Issue type : kbhowto