Post reply

Invalid Object Name

  • February 1, 2012 at 6:19 am

    #99946

    Hello all,

    I have a table users in a Database comp.

    when i specify insert into comp.<username>.users it gives me an error invalid object name.

    Is it not possible to use the db name in the same database.

    Usually we specify it as users alone.

    thanks and regards,

    K. sripriya

  • February 1, 2012 at 6:21 am

    #1441183

    Is the object in the <username> schema?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 1, 2012 at 6:24 am

    #1441184

    Thank you for the response. Got the clue and now it works fine.

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

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