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

    Unanswered: Select Table Problem

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

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

    	select  *  from [tablename]

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    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.

    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