VSS & SQl2000 integration

[Licemjer]

I have a need integrating SQL2000 & VSS. Is there a simple way or any other
way to do it? There are some undocumented procedures in SQL2000 which are to
help one to integrate SQL database into VSS. Does anyone have documentation
about those procedures? Or, is there a tool which makes it easyer? Thanks in
advance for any help.

[Erland Sommarskog]

Re: VSS & SQl2000 integration

[posted and mailed, please reply in news]

Licemjer (licemjer@licem jer.hr) writes:[color=blue]
> I have a need integrating SQL2000 & VSS. Is there a simple way or any
> other way to do it? There are some undocumented procedures in SQL2000
> which are to help one to integrate SQL database into VSS. Does anyone
> have documentation about those procedures? Or, is there a tool which
> makes it easyer? Thanks in advance for any help.[/color]

I notice that you posted this question to
microsoft.publi c.sqlserver.pro gramming as well. Please do not post the
same question to different groups independently. This can result in
persons spending time on researching a question, when it already has
been answered appropriately elsewhere.

As for your question, there is integration in Visual Interdev 6 and
in VS .Net. The one in VI6 is completely wrong, because SQL Server
is the one that interacts with SourceSafe, and thus the user under
which SQL Server runs under gets credited for the checkins, which is
unacceptable.

Personally, I have found integration overvalued, and I find access from
VSS Explorer to be fully sufficient. I use the same editor for SQL files
that I use for any text files. Therefore I can right-click and choose
Edit and the file opens in Textpad. If you want to use Query Analyzer,
you can add this to your SS.INI:

.sql = C:\program files\microsoft sql server\80\tools \binn\isqlw.exe


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

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp