Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2004
    Posts
    30

    Question Unanswered: Server: Msg 208, Level 16, State 1, Line 1

    Hello All,

    This table was created by coldfusion and has been given all priviliges to public and I am in the public group but I still cant select from it. It gives me this error message: Server: Msg 208, Level 16, State 1, Line 1. Help!

    Thanks in Advance.

  2. #2
    Join Date
    May 2004
    Location
    Ohio
    Posts
    61
    post the code dude

  3. #3
    Join Date
    Oct 2004
    Posts
    30

    Question

    Here is the code:

    select * from delete_acq_requests

    returns the error message:

    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name 'delete_acq_requests'.

    This object gave all permissions to public and I am a user in public. Thanks.

  4. #4
    Join Date
    May 2004
    Location
    Ohio
    Posts
    61
    Verify the name of the table in the database in your object browser, and is the correct database selected from the dropdown menu at the top in Query Analyzer?

  5. #5
    Join Date
    Oct 2004
    Posts
    30

    Question

    Yes, I did verify the name in the object browser and made sure the name was typed in correctly. Yes, I am in the ats database when doing my select statement.

  6. #6
    Join Date
    Aug 2004
    Posts
    8
    Check the table's owner. If it's not dbo, you should use <owner>.delete_acq_requests to refer to it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •