sql complains about the hyphen in the server name.

• invaliddba

  Default port

  Points: 1450

  More actions

  March 28, 2011 at 6:04 pm

  #389158

  select * from WINSER2003-I.secls.dbo.employee.

  sql server complains about -. How do I resolve this?

• Krystyna Mularczyk

  SSC Enthusiast

  Points: 190

  More actions

  March 28, 2011 at 6:10 pm

  #1304633

  Add brackets whenever the name contains special characters:

  select * from [WINSER2003-I].secls.dbo.employee

• invaliddba

  Default port

  Points: 1450

  More actions

  March 28, 2011 at 7:32 pm

  #1304644

  When I tried to run select * from [WINSER2003-I].secls.dbo.employee

  I get this error

  Invalid object name 'secls.dbo.employee'.

• RP_DBA

  SSCertifiable

  Points: 5116

  More actions

  March 29, 2011 at 7:48 am

  #1304861

  Don't have a lot to go off here but I'd double check to make sure the employee table is in the dbo schema.

  _____________________________________________________________________
  - Nate

  @nate_hughes

• chetanr.jain

  Hall of Fame

  Points: 3938

  More actions

  March 30, 2011 at 7:47 am

  #1305444

  As RP said, your table will not be in the same directory.

  check in the object explorer.