Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Brazil
    Posts
    4

    Thumbs down Unanswered: Invalid Object Name

    I restored all Databases in other server.

    First I restored the master database and after the others databases. But when I connect by Query Analyser with a user that is a DBO and I execute a select the system return : "Invalid object name 'XXXX'"

    My MS-SQL is the version 7.0.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    What happens when you run this query on that database:

    select uid, name
    from sysobjects
    where name = 'XXXX'

    where 'XXXX' is the name of the table you are after.

Posting Permissions

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