May 1, 2002 at 10:10 am
I can't understand this!
Recently installed 2000 and created 2 new databases.
Basically, I can connect to Query Analyzer easily enough but as soon as I put in the simplest query on any DB apart from Master I get
Msg 208 Level 16
Invalid Object name "Products"
That is for select * from products in Northwind DB.
Silly thing is that in Object Search I can see any object(table name) I like.
The parse is good.
sa has not been touched, it has a blank password, it is a db_owner for all databases.
What is going on??!!!
May 1, 2002 at 10:34 am
Two things off the top of my head, either the object is owned by someone else i.e. ptarry.Products, or you have some type of case sensitivity that is hitting you and you need to specify that table name in the proper case structure i.e. select * from Products (vs. products).
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 1, 2002 at 10:45 am
Phew!
It was the case sensitivity. I was going bonkers there!
Any idea how I can get rid of the sensitivity?
Anyway, thanks very much.
PT
May 1, 2002 at 10:53 am
BOL has following info:
A sort order ...determines the sequence of rows in the result set of a query.
The sort orders available depend on the character set you chose. You cannot have different databases with different sort orders on the same server. In addition, you cannot back up and restore databases between servers configured for different sort orders.
Important It is critical that you select the correct sort order when you install SQL Server. If you need to change sort orders after installation, you must rebuild your databases and reload your data.
Edited by - EPol29 on 05/01/2002 10:53:25 AM
May 1, 2002 at 3:39 pm
If it is a fresh install of SQL and no critical data on the server then run uninstall then do reinstall and choose custom to make sure you can get the sort order/collation you want so you can use case insensitive.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply