[This topic is migrated from our old forums. The original author name has been removed]
Hi,
Started getting errors around 'GO' after upgrading to 9.2.4.
Just happened to notice the ones with lowercase 'go' worked fine.
Changing 'GO' to 'go' will run fine as in the sample below.
eg.
GRANT SELECT ON [dbo].[pension_benefit_rate] TO [EFG_CORPORATE\HR_PENSION_ADMIN_PL] AS [dbo]
GO
Returns message:
10:17:28 [GRANT - 0 row(s), 0.000 secs] [Error Code: 102, SQL State: 42000] Incorrect syntax near 'GO'.
GRANT SELECT ON [dbo].[pension_benefit_rate] TO [EFG_CORPORATE\HR_PENSION_ADMIN_PL] AS [dbo]
go
returns:
10:18:05 [GRANT - 0 row(s), 0.019 secs] Command processed. No rows were affected
Connection information
Microsoft SQL Server 10.50.1600
jTDS Type 4 JDBC Driver for MS SQL Server and Sybase 1.2.8
Product information
Product: DbVisualizer Pro 9.2.4 [Build #2423]
OS: Windows 7
OS Version: 6.1
OS Arch: x86
Java Version: 1.7.0_76
Java VM: Java HotSpot(TM) Client VM
Java Vendor: Oracle Corporation
Java Home: c:\program files (x86)\dbvisualizer\jre
DbVis Home: C:\Program Files (x86)\DbVisualizer
anonymous