When saving the below syntax, the Toad-SS 5.7.0.452 drop says that ‘::’ is “Incorrect syntax near ‘::’.
This is an editor parsing bug.
USE [GCMA_AIT];
go
--GRANT execute ON SCHEMA :: APP TO [GcmaAitUser];
go
grant execute on database :: [GCMA_AIT] to [GcmaAitUser];
--Category Timestamp Duration Message Line Position
--Parser Messages 4/30/2012 3:18:30 PM line 125, col 27: Incorrect syntax near '::'
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
hfreeman@msn.com
678.414.0090 my cell Primary
Hank.Freeman50 (Skype)
