Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008
    Posts
    117

    Unanswered: Select Table Problem

    I am using Microsoft SQL Server 2008 Management Studio. The tables are only getting selected with this

    Code:
    	select  *  from [database].[user].[tablename]
    But saying no object error with this

    Code:
    	select  *  from [tablename]

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    When in dobut, use the fully qualified name.

    You can ensure that your SQL session is using the correct database via USE (Transact-SQL)

    The schema is a bit trickier, but if it is either your user name or dbo you should be fine, otherwise provide the schema name along with the table name.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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