[Gllug] Accessing MS SQL Server from linux

[Matthew King]

Ben Whyte <ben at whyte-systems.co.uk> writes:

> Gunde is right, GO causes the tools such as query analayser to force the
> execution of the code waiting to be run.
>
> It is not manditory in any way but until GO has been called you can not
> gaurentee when the code will run.
>
> I.e. if you make a schema change and then want to manipulate this if you
> dont call go there is a chance that the schema change will not have been
> applied.
>
> So on the product I work on our deployment script has to have at least a
> go at the end of each individual script to ensure execution in the
> desired order.

I'm not MS bashing (this time) but what is the point in this? It sounds
like a poor attempt at transactions.

Does MSSQL have transaction support?

Matthew

-- 
I must take issue with the term "a mere child", for it has been my
invariable experience that the company of a mere child is infinitely
preferable to that of a mere adult.
                                           --  Fran Lebowitz

-------------- next part --------------
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug