Is a ''-'' (minus sign) valid in a linked server name.

• Scott Rouse

  SSC Enthusiast

  Points: 179

  More actions

  July 24, 2006 at 10:39 am

  #366938

  I'm trying to pull data from a SQL 2000 server to a SQL 2005 server using a linked server.

  I added the linked server via a right click on the linked server option.

  The server created without a problem, but when I query it with:

  select * from openquery(my-database,'select * from FIS..vw_Employee')

  I get this error:

  Msg 102, Level 15, State 1, Line 5

  Incorrect syntax near '-'.

  I've tried escaping the '-' with \,\\,/, // single and double quotes.

  Is a minus sign valid in a server name?

  This will move to DTS at a later date, but I thought this would be a simple, quick fix.

  Thanks,

  Scott

• Cory E.

  SSCertifiable

  Points: 7076

  More actions

  July 24, 2006 at 11:00 am

  #651149

  Yes, this will work.  What you need is to wrap brackets around the linked name.

  select

  * from openquery([my-server],'select * from FIS..vw_Employee')

  -- Cory

• Scott Rouse

  SSC Enthusiast

  Points: 179

  More actions

  July 24, 2006 at 11:11 am

  #651150

  That works.

  Thanks

  Scott