Invalid Object Name Problem - Grrr

• Andrew Slapp

  Old Hand

  Points: 398

  More actions

  April 4, 2005 at 10:23 pm

  #88465

  Hi All,

  I hope you can help because I am going mad with this problem.

  I have created a stored procedure named procImportCTC

  When I try to run the command in QA to test it I get the following error message:

         Server: Msg 208, Level 16, State 3, Procedure procImportCTC, Line 11

         Invalid object name 'ctcTransactions

  My research has lead me to believ this is a permissions problem.

  I have tried all the prefixing of CTC.dbo.procImportCTC and also dbo.procImportCTC but none of these work. I have checked the permissions for the dbo and it seems to have permissions to access this table. I have my default database set to CTC which contains the table ctcTransactions.

  Why am I getting this error. I am under the impression it is either a permission problem or an "MS" problem. I can see the object in QA object browser so I dont know what its problem is. The owner of the table is the dbo checking this with the query in QA.

  Any ideas appreciated

  THANKS HEAPS

   

   

• Andrew Slapp

  Old Hand

  Points: 398

  More actions

  April 4, 2005 at 11:13 pm

  #550442

  After struggling with this problem for nearly 2 days, as soon as I posted I worked out the problem.

  Just incase anyone is interest if you are receiving this error it could also be to do with the table structure.

  My example was saying that the table didnt exist but this was because I was passing incorrect parameters to the table based on the table structure

   

  Kind Regards