Post reply

I am gerting an error Invalid Object name

  • February 22, 2010 at 8:14 am

    #215991

    When i try to execute my procedure i am getting

    Cannot find the object "tablename " because it does not exist or you do not have permissions.

    But the table is there and i created it, i did make sure the names are correct to ,i don't know why i am getting this error.

    i am trying to insert the values into the table in my procedure ,when i execute only insert syntax it is pulling the rows ,but when i try to do the same thing using procedure i am getting above error...

    Appreciate the help

  • February 22, 2010 at 8:20 am

    #1122980

    I got it .

    I am executing the procedure with execute as 'name'

    looks like i don't have permission for the name i have given .

    Thanks

  • February 23, 2010 at 5:26 pm

    #1123998

    Another thing that trips people up is objects owned by a schema other than "dbo".

    You might run this, which assumes "dbo" select * from TableA

    when in fact you should run:

    select * from SchemaB.TableA

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

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