Hi=2E

I'd appreciate some help related to setting up vs to use Visual=
Source Safe to back up some stored procedures=2E Am using=
MSSQLSErver Enterprise Edition 8=2E00=2E194=2E Have installed VSNET=
Professional=2E Microsoft Development ENvironment is version=
7=2E1=2E3088 and =2ENET framework is 1=2E1=2E4322 SP1=2E Visual Source Safe=
is Version 6d (build 9848)=2E Basic problem is that the tick box=
to enable source control for stroed procedures is greyed out and=
I cannot find a way to unlock this=2E Also seems like this is not=
a common problem as there is little on the web about this=2E

Any suggestions would be welcomed=2E

Thanks

--------------------------------
From: John Sumiga

-----------------------
Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/)

John,

Where is the source code for the stored procedures? Are you just pointing
VS.NET to a database server (via a database project)? If so, I am not sure
if you can use VSS for this. I don't know what the recommended approach here
is, but from what my team does and from what I saw other teams doing,
basically VS.NET is used like a text editor. All Transact-SQL scripts to
build stored procedures (as well as tables, etc) are stored as simple text
files; they are not part of any particular project. I just add an external
tool shortcut to VS.NET menu to compile stored procedures (without having to
switch to Query Analyzer), so I do not use a database project for this; it's
too much overhead. In VSS, I have a separate project (folder) for stored
procedures (and other Transact-SQL) source code.

If my assumptions are wrong, please clarify, where and how you keep the
source code of the stored procedures. Keep in mind, that compiled code (in
database) cannot be source controlled, only source files can.

Alek

[quoted text, click to view]
Hi.

I'd appreciate some help related to setting up vs to use Visual Source Safe
to back up some stored procedures. Am using MSSQLSErver Enterprise Edition
8.00.194. Have installed VSNET Professional. Microsoft Development
ENvironment is version 7.1.3088 and .NET framework is 1.1.4322 SP1. Visual
Source Safe is Version 6d (build 9848). Basic problem is that the tick box
to enable source control for stroed procedures is greyed out and I cannot
find a way to unlock this. Also seems like this is not a common problem as
there is little on the web about this.

Any suggestions would be welcomed.

Thanks

--------------------------------
From: John Sumiga

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>y5Om9RpyfEWcpwDfYbrsdw==</Id>

John Hi!

Contact me at the above email address.

Ewen Arnold

---

John Hi

Contact me at mahakand@omantel.net.o

Ewen Arnold

---