Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    5

    Question Unanswered: Can't access table due to no owner (I think)

    I can't access a number of tables on my SQL Server 7.0 database. Have checked using Enterprise Manager and the table does not appear to have any owner. When trying to do anything with the table I always get the following message

    {SQL-DMO} The name 'Table Name' was not found in the tables collection. If the name is a qualified name, use [] to seperate various parts of the name, and the try again.

    Have tried to change the owner by using sp_changeobjectowner but I am either getting the syntax wrong or it ain't working.

    Any ideas??????

    c8l

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    When you look in Enterprise Manager, what do you see?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2003
    Posts
    5
    Hi,

    The only thing I see is the table name (TABLE1), the type (USER) and the creation date. The owner column is blank. Normally you would expect it to say dbo.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Blank?

    What happends when you run this in QA?

    SELECT * FROM INFORMATION_SCHEMA.Tables


    Maybe you need to close EM and relaunch it. ...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Sep 2003
    Posts
    5

    Talking

    Thanks for the help but the problem has been resolved, I had to manually update the sysobject table so that the UID for each of the objects that could not be accessed was set to 1. For some reason this was 6.

    Cheers
    c8l

Posting Permissions

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