Re: Integration between VSS and SQL Server

Tech-Archive recommends: Fix windows errors by optimizing your registry

lepa71_at_gmail.com
Date: 02/22/05 

Date: 22 Feb 2005 07:29:06 -0800

Hi
I tried to use isqlw.exe like you suggested but when it opens a SP it
is set to "Create" instead of "Alter". How can I fix that?

Thanks

Erland Sommarskog wrote:
> [posted and mailed, please reply in news]
>
> Fernando Parreiras (fparreiras@b2i.com.br) writes:
> > I'm trying to integrate VSS and SQL Server through VID.
> > The VID adds all the Stored Procedures to the VSS
> > Database, but when I try to check them out the option in
> > the VID is disabled. I can add the SPs but I can't check
> > them in or out.
>
> Good. That it is not working, that is.
>
> The integration in Visual Interdev has it all backwards. You don't
> add your source code to version-control that way. Since the
procedures
> are scripted out from SQL Server, you are in fact putting
disassembled
> versions of your code under source code.
>
> OK, scripting usually is correct, but there are worse matters. You
> cannot handles the tables the same way, so it's only a half-baked
> solution.
>
> But what it is a lot worse: the checkins are credited to the user
> that SQL Server runs under, and not the developer that actually
> makes the changes. And this is completely unacceptable.
>
> Use VSS Explorer for all checkins and checkouts. For editing stored
> procedure, Query Analyzer might do. You can add this line to your
> SS.INI:
>
> .sql = C:\program files\Microsoft SQL Server\80\Tools\isqlw.exe
>
> So when you right-click on a file and choose Edit, you will open
> it in Query Analyzer.
>
> Even better might be to use an external editor, such as Textpad or
> UltraEdit. (www.textpad.com, www.ultraedit.com.) You can easily set
> up a command-line tool in these editors, so you can submit an SP
> through a keypress in the editor.
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@algonet.se
> I support PASS - the definitive global community for SQL Server
> professionals - http://www.sqlpass.org
> The PASS Community Summit is in Seattle Nov 19-22, I'll be there. And
you?

Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... communication between ODBC (OLEDB and Native Client, ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)
  • Switching a Forms Recordsource at RunTime to a SP w/ a Parameter
    ... 2003 and SQL Server 2K) for the past few months, ... then opens the target form. ... Dim cnn As ADODB.Connection ... Dim cmd As ADODB.Command ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Fonts and Colors items are not well documented
    ... I recently picked up ownership for all of the Management Studio query editor topics by virtue of being the writer for the Transact-SQL Intellisense and Debugger work for SQL Server 2008. ... There is further IntelliSense work in the next Katmai release, along with the new Transact-SQL debugger that was announced with the SQL Server 2008 a couple of months ago. ...
    (microsoft.public.sqlserver.tools)
  • Re: How do you run a .sql script?
    ... It'll ask you to login, I'm guessing that the default settings should work. ... If you are using SQL 2005, look for SQL Server Management Studio. ... Once the file is opened, make sure the current database is Master. ... just opens in Notepad. ...
    (microsoft.public.vstudio.general)
  • Re: Mail merge conversion from Word to .NET code.
    ... I've experienced similar agonies trying to automate Word using C#, ... >- The data will be pulled from a stored procedure residing in a SQL Server ... >happens when Word opens and tries to do the merge, ... >the SQLStatement parameters of the OpenDataSource method. ...
    (microsoft.public.word.mailmerge.fields)