Haha.... I made the effort to read some of Mr Celko's previous posts sometime ago... Lol he really lets loose sometimes but you know he does make some valid points. It's just his style is so damn rude!!
Take it wth a shovel of salt. 😀
Anyway, as GSquared said, GO is not a TSQL command, it's just a word that SSMS uses to know that you want to send a bunch of code in one batch.
You say you have 30 scripts and some are dependent on others then you must also know the order the must run yes?
If so then why not
A) open new .sql file, copy and paste content of the first script, add a GO then paste in the second script and so on.
b) schedule a sql agent job and place each script in its own step.
C) create SSIS package with as a series of execute TSQL components
D) batch file
Thanks.
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn