Query

Hot Topic

SQL Server 2005 did not install
Is it possible to convert the sample C# program AmoAdventureWorks in "C"??
I've got the June CTP Sql 2005 but SSIS doesn't work
Running individual tasks in ISS
System variable containing minimum allowed value for int?
SAN Replication
SSIS import problem from ODBC source.
Upgrade to Advanced Services; full-text indexing not working
Urgent: ASP.NET 2.0 and SQL 2000
combining 2 select with count and datediff into 1 select. need help.

SQL Server

SQL Native Client Issue
Gauge Controls for Reporting Services 2005
Naming convention for partitions
Generated query
Create user error!
Iteration within Stored Procedure
question on using xp_cmdshell
ActiveX Script Task - SSIS
its not few, its galaxy of problems for me.....
Error: "no report servers were found on the specified machine"

Query

I have attached the Adventureworks database to SQL Server 2005.

Whenerver I try to run a new query to this database

Ex: select * from sales.customer

I get this error message

Msg 208, Level 16, State 1, Line 1

Invalid object name 'sales.customer'.

I don't know why this is happining




Answer this question

Query

  • ingrosso

    Hi,

    make sure you are deling with the right database (Select db_name()).

    Didi you change the default collation Seems that you are using a CS Coallation, that means that its case sensity, you can check that by using the query:

    SELECT databasepropertyex('Adventureworks','collation')

    Select * from Sales.Customer

    So I guess, if you *are* connected to the right database, you should be fine using the proper typing of the name (otherwise, if you are feeling not comfortable withthis solution, you could change the collation of the database, by using the statemetn ALTER DATABSE, look in the BOL for more information)

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • Brandon Schenz

    Thanks a lot Jens

  • Query
Answer this question