Post reply

MSG 208

  • September 27, 2005 at 6:52 am

    #165342

    Hi,

        I' new to SQL Server and I hope I can get some help with my problem.  We received a SQL Server database from another site.  We restored the database into our local server.  The tables came in pre-fixed with the name of the owner in the source database.  The properties sections lists sa as the owner.  We can right click on a table and display the records but no user, including sa, can query any of the tables.  We get

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

    Invalid object name 'content'.

    Can someone please tell me how to fix this problem?  Thanks.

    e

  • September 27, 2005 at 7:13 am

    #593257

    Can we see the code you are using?

  • September 27, 2005 at 7:36 am

    #593270

    I'm doing

    Select * from tablename

    in Query Analyzer.  I get this message even when I'm logged in as sa.  Thanks for any help you can provide.

    Elaine

     

  • September 27, 2005 at 8:00 am

    #593278

    That can't be the query you are running as there's no syntaxe error in there. Please post the code that ERRORS OUT.

  • September 27, 2005 at 8:07 am

    #593283

    G'Day,

    I get this error about twice a week when moving objects from the development environment into QA.  It is usually one of two things - either the object is missing, or the object owner was not properly changed when the new object was deployed into QA.  I would guess that the userids in the restored DB have not been resynched with the userids on your server.  If the userids have been synched up, try running sp_changeobjectowner to reset the table owner to dbo.

    RUN BACKUPS FIRST.

    Hope this helps

    Wayne

Viewing 5 posts - 1 through 4 (of 4 total)

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