Home Forums SQL Server 2005 Administering Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '-'. RE: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '-'.

  • You have to enclose the object names in [] when the object name contains special characters, keywords etc.

    select * from [cic-nic-2].Arrow.dbo.circle

    --Ramesh