Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

MS Integration of VSS and SQL Server exists?

2 views
Skip to first unread message

Laurence Neville

unread,
Jul 30, 2003, 12:33:38 PM7/30/03
to
I am looking for a way to automate (to whatever extent is possible) the
checking in of SQL Server object creation scripts into Visual Source Safe
for version control. I was searching the Microsoft site today and found this
page which seems to indicate some kind of integration exists:

----------------------------------------------------------------------------
-------------------------
http://support.microsoft.com/default.aspx?scid=kb;en-us;313993

BUG: VSS Database Truncates Stored Procedures Larger Than 4 KB
The information in this article applies to:
Microsoft Visual SourceSafe, 32-bit, for Windows 6.0
Microsoft SQL Server 2000 (all editions)

This article was previously published under Q313993
SYMPTOMS When you check in stored procedures that are larger than 4 KB,
anything after the 4 KB limit is truncated in the Visual SourceSafe (VSS)
database. The stored procedure is never truncated in the SQL Server
database.

etc
----------------------------------------------------------------------------
-------------------------

This can't refer to manually checking in scripted stored procedures because
I have never experienced any being truncated. What does this refer to ??


Andrew J. Kelly

unread,
Jul 30, 2003, 12:57:36 PM7/30/03
to
There is no real direct integration with SQL Server and VSS. You can use
Visual Studio to do some of it but it's not a native task. This may be of
interest: http://www.mssqlxpress.com/

--

Andrew J. Kelly
SQL Server MVP


"Laurence Neville" <laurenc...@hotmail.com> wrote in message
news:BrSVa.4618$gX5....@newssvr23.news.prodigy.com...

Erland Sommarskog

unread,
Jul 30, 2003, 5:00:16 PM7/30/03
to
Laurence Neville (laurenc...@hotmail.com) writes:
> I am looking for a way to automate (to whatever extent is possible) the
> checking in of SQL Server object creation scripts into Visual Source
> Safe for version control. I was searching the Microsoft site today and
> found this page which seems to indicate some kind of integration exists:

Yes, there is a feature in Visual Interdev 6 and also in VS .Net.
The one in Interdev you should stay away from, because it does it
all wrong. Things gets checked in by the user under which SQL Server
runs. How VS .Net does I have not tried.

Personally, I use VSS Explorer for checking and a third-party text
editor (not SQL aware) for my SQL editing. Works perfectly.

--
Erland Sommarskog, SQL Server MVP, som...@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

0 new messages