GO xxx

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

GO xxx

Postby fatherjack » Fri Feb 13, 2009 10:24 am

Hi,

SQL MultiScript seems to have a problem when a script has a GO statement with a number following it
eg:
SELECT GETDATE()
GO 15

I think SQL Prompt has problems too ...

Regards

Jonathan
-----------------------------------------
Senior DBA
Careers South West Ltd
fatherjack
 
Posts: 224
Joined: Tue Mar 13, 2007 12:33 pm
Location: Cornwall

Postby dlkj » Mon Feb 16, 2009 10:48 am

Hi Father Jack,

the batch separator (which is configured by default to be GO) and its relating syntax are not features of SQL Server. They are entirely part of SQL Server Management Studio.

As such, we decided support batch separators, but we have chosen not to support the <batch separator> nnn syntax.

This is already listed in our bug track system as issue SE-395

Cheers,
--
Daniel
dlkj
 
Posts: 151
Joined: Tue Aug 14, 2007 5:10 pm
Location: Red Gate Software, Cambridge


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests