Post reply

sql complains about the hyphen in the server name.

  • March 28, 2011 at 6:04 pm

    #389158

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

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

  • March 28, 2011 at 6:10 pm

    #1304633

    Add brackets whenever the name contains special characters:

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

  • 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'.

  • 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

  • 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.

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

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