How To Put Stored Procedures Under Remote Source Control in Visual InterDev 6.0 (199204)


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 7.0
This article was previously published under Q199204

SUMMARY

This article describes how to put SQL Server stored procedures under Visual InterDev 6.0 source control when Microsoft Visual SourceSafe is not on the SQL Server computer.

MORE INFORMATION

There are two distinct configurations for placing stored procedures under source control:
  • The Visual SourceSafe database is installed on the same computer as SQL Server. For this configuration, see the following article in the Microsoft Knowledge Base:

    201240 How To Put Stored Procedures Under Source Control in Visual InterDev

  • Visual SourceSafe is installed on a computer remote from SQL Server, as shown in the following procedure.

Stored Procedures Under Source Control with Visual SourceSafe on a Remote Computer

  1. Install the SourceSafe client components on the SQL Server computer. You can do this by running Netsetup.exe from the directory of the computer that has the Visual SourceSafe database installed on it.
  2. Change the MSSQLServer (SQLExecutive on SQL Server 6.5) service to run under a user account that has access to the remote computer and is a user on Visual SourceSafe. SQL Server uses this account to log on to the remote server in order to check files in and out of Visual SourceSafe.
  3. Install the Visual InterDev Server Components on the SQL Server computer. These are found on CD-ROM 2 of Visual Studio by running the Setup.exe file in the \VID_SS folder.
  4. On the client, open Visual InterDev to your project that has the database connection and follow these steps:

    1. In Data View, open the connection to the database by clicking on the plus sign next to the database name.
    2. Right-click the database name and select Add to Source Control. The Enable Source Control dialog box appears.
    3. Type the local path (relative to SQL Server) to the Srcsafe.ini file located on the SQL Server computer. You can also enter a universal naming convention (UNC) path if the database is different from the one where you ran Netsetup.
    4. Type the name of the source control project that you want to create and click OK. (NOTE: This should not include the "$/" because Visual InterDev will put that in for you.)
    5. Enter a valid SourceSafe logon ID and password and then click OK. This user ID and password must be for 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 computer.
    Stored procedures successfully placed under source control display a lock icon.

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

233348 BUG: Variable Uses Automation Type Not Supported Error

234906 BUG: Source Control Times Out When Adding Stored Procedures

193232 INFO: Readme.txt for Visual InterDev 6.0


For more informatioin about versioning stored procedures with Visual Studio 6.0 and SQL Server 7.0, see the following Microsoft Web site:

http://msdn.microsoft.com/library/en-us/dnsql7/html/sql7storprocvers.asp

Modification Type:MinorLast Reviewed:7/2/2004
Keywords:kbhowto kbStoredProc KB199204
©2004 Microsoft Corporation. All rights reserved.