473,326 Members | 2,013 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Stored Procedure Source Control

Hi,

I am trying to put SQL Server Stored Procedures into Sourcesafe as per
the Microsoft Knowledge Base article 818368, but have run into a
problem.
The web server is SQL Server 2000 running on Windows 2003 Server. The
client dev environment is Visual Studio 2003 Enterprise Developer
Edition.

I have carried out the following steps successfully:-

1. Installed Sourcesafe client tools on the Server (sourcesafe is on
another server)
2. Run the MSSQLServer service under a domain account that has Read
and Write access to the Sourcesafe database.
3. Added the above user to Sourcesafe using the Administrator tool.
4. Installed the VS6 Stored Procedure Version Control components on
the Server
5. Enabled Version Control for Stored Procedures on the client

However when I right-click on the Stored Proc node in Server explorer
I do not get any of the Sourcesafe menu options. They are not greyed
out, they are simply not there!

Any help would be appreciated.

Alternatively if anyone has recommendations for other strategies or
other tools to use for this purpose than Sourcesafe then this would
also be welcome

Karl
Jul 20 '05 #1
1 2344
Karl (ka*********@gmail.com) writes:
I am trying to put SQL Server Stored Procedures into Sourcesafe as per
the Microsoft Knowledge Base article 818368, but have run into a
problem.
The web server is SQL Server 2000 running on Windows 2003 Server. The
client dev environment is Visual Studio 2003 Enterprise Developer
Edition.

I have carried out the following steps successfully:-

1. Installed Sourcesafe client tools on the Server (sourcesafe is on
another server)
2. Run the MSSQLServer service under a domain account that has Read
and Write access to the Sourcesafe database.
3. Added the above user to Sourcesafe using the Administrator tool.
4. Installed the VS6 Stored Procedure Version Control components on
the Server
5. Enabled Version Control for Stored Procedures on the client

However when I right-click on the Stored Proc node in Server explorer
I do not get any of the Sourcesafe menu options. They are not greyed
out, they are simply not there!


That's probably a good thing.

There is a serious flaw with the process outlined in that KB article.
As I understand it, checkins will be performed by the user under which
SQL Server runs, and not the actual user. This is completely unacceptable.
Note also that what this method does, is to check in disassmbled code. True,
the "assembling" consists of slicing the text into 8000 long pieces in
syscomments, but nevertheless. Finally, a shortcoming is that you cannot
version-control tables this way.

So how to do it? There are a couple of third-party tools, but I have not
investigated them. In our shop we simply use VSS Explorer to check things
in and out. The stored procedures, tables etc are simply text files just
like any other source code. We don't use VS for SP editing, but instead
we use Textpad (www.textpad.com), a third-party editor, with no
particular SQL support. But it's a better editor than Visual Studio in
my opinion. To load the procedures we fire a command-line tool from
Textpad. In our case the command line tool is a homebrew with quite some
bells and whistles. (Available as freeware on http://www.abaris.se/abaperls)
But you could use OSQL instead.

Of course you could still edit in VS .Net and use VSS Explorer to check
in out. At least if VS .Net supports saving SQL files to disk.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: dinesh prasad | last post by:
I'm trying to use a servlet to process a form, then send that data to an SQL server stored procedure. I'm using the WebLogic 8 App. server. I am able to retrieve database information, so I know my...
0
by: Nashat Wanly | last post by:
HOW TO: Call a Parameterized Stored Procedure by Using ADO.NET and Visual C# .NET View products that this article applies to. This article was previously published under Q310070 For a Microsoft...
1
by: CLS | last post by:
I have installed the stored procedure / sourcesafe integration from the VS.NET 2003 CD. I've created a new solution and added a database project to it and put it under source control. I've...
3
by: Ryan.Chowdhury | last post by:
This is a general question regarding the use of view and stored procedures. I'm fairly new to databases and SQL. I've created a SQL database using an Access Data Project ("ADP") and I'm...
1
by: Evgeny Gopengauz | last post by:
Hi! I need to write a t-sql-script like this: (case-1) IF {stored procedure SP is not exists} BEGIN CREATE PROCEDURE SP AS BEGIN //dummy body END
2
by: singlal | last post by:
Hi, my question was not getting any attention because it moved to 2nd page; so posting it again. Sorry for any inconvenience but I need to get it resolved fast. Need your help! ...
10
by: Dick | last post by:
Using Visual Studio 2003 you were able to manage SQL stored procedures with Visual Source Safe. So long as Visual Studio was used as the editor, it was imposible to make a change to a stored...
4
by: PJackson | last post by:
I have been given the task of taking a 3,200 line COBOL stored procedure and duplicating the same functionality in UDB 7.2 on the Windows platform with a procedural SQL stored procedure. I have...
1
by: sheenaa | last post by:
Hello Members, I m creating my application forms in ASP.Net 2005 C# using the backend SQL Server 2005. What i have used on forms :: ? On my first form i have used some...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.