Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 incorrect syntax near '-'

Author  Topic 

splearner
Starting Member

3 Posts

Posted - 2011-07-28 : 03:19:11
hi,
i am trying to copy contents of one table on one DataBase server to another Database Server. below is the query

INSERT INTO CC-MOSS\SQLEXPRESS.APS.dbo.APSInformation(SELECT * FROM [CC-MOSS.APS.dbo.APSInformation])

when i run this query i get this error 'incorrect syntax near '-'

please help.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-07-28 : 03:27:59
[server].[database].[dbo].[APSInformation]


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -