Post reply

Invalid object name with '_'

  • July 22, 2003 at 2:55 pm

    #160281

    I have tables such as _Client_, _ACTIONS_ etc owned by _SMDBA_(Vendor specified), when I tried to use 'Select.. from .. where' clause, it returned the message "Server: Msg 208, Level 16, State 1, Line 1

    Invalid object name '_ACTIONS_'."

    Any ideas? Thanks!

  • July 22, 2003 at 3:02 pm

    #466474

    Have you tried

    Select * from [_Actions_]

  • July 22, 2003 at 3:12 pm

    #466477

    ...or you might even need to qualify it with the owner name:

    Select * from [_SMDBA_].[_Actions_]


    Cheers,
    - Mark

  • July 23, 2003 at 5:13 am

    #466559

    Refer BOl - This error occurs when an object that does not exist is referenced. If the object exists, you might need to include the owner's name in the object name.

    If the object is not owned by the user attempting to access it, and it is not owned by the database owner, all references to the object must include the owner's name. For example, if user1 creates a table called test, other users must use the name user1.test when they refer to the table.

    The underscores should not be an issue.

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

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