[posted and mailed, please reply in news]
Licemjer (li******@licemjer.hr) writes:
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.
I notice that you posted this question to
microsoft.public.sqlserver.programming 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,
so****@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp