sql complains about the hyphen in the server name.

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

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

  • Add brackets whenever the name contains special characters:

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

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

    I get this error

    Invalid object name 'secls.dbo.employee'.

  • 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
  • As RP said, your table will not be in the same directory.

    check in the object explorer.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply