|
|
You're in the
sql server programming
group:Can't query attached database
sql server programming:
use <owner>.<tablename> Regards Partha Mandayam Software Consultant Home page: http://partha.tripod.com *** Sent via Devdex http://www.devdex.com ***
Hello.
I received a detached database/log from my client. I attached the database to my SQLServer 2000 SP3 installation just fine. In the enterprise manager I can query any table I want. However, when I attempt to query a table via the query analyzer, it always fails, even though I am logged in as the "sa". Below is my query and the result. I am not having this trouble with any other database on the system. select * from employee Below is the error message: Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'employee'. Any help would be appreciated. Thanks, Christian pariahware@pariahware.com Pariahware, Inc. Custom Software and Shareware http://www.pariahware.com -- God loved you so much that He gave His only son Jesus.
In article <uwTZNx9UEHA.1048@TK2MSFTNGP09.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> [quoted text, click to view] wrote: Yes, I can view it in the enterprise manager.> Is there really a table called employee? [quoted text, click to view] > Are you in the right database? Yes, I've even used the "use" command to make sure, on occassion.[quoted text, click to view] > Who is the owner of that table? The owner of the table is "dbo".When I look under the db's users, "dbo" is a name entry, "sa" is the
In article
<pariahware-21E05C.16194316062004@news2-ge0.southeast.rr.com>, [quoted text, click to view] Christian Miller <pariahware@pariahware.com> wrote: > In article <uwTZNx9UEHA.1048@TK2MSFTNGP09.phx.gbl>, > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> > wrote: > > > Is there really a table called employee? > Yes, I can view it in the enterprise manager. > > > Are you in the right database? > Yes, I've even used the "use" command to make sure, on occassion. > > > Who is the owner of that table? > The owner of the table is "dbo". > > When I look under the db's users, "dbo" is a name entry, "sa" is the > login name and access is "permit". OK, apparently there is not a database table called "employee", but there is one called "EMPLOYEE". I don't ever remember table name case being an issue when performing a querying before. I normally uppercase key words and lowercase table names. Is this a setting in my SQL Server that I accidentally set? Thanks, Christian pariahware@pariahware.com Pariahware, Inc. Custom Software and Shareware http://www.pariahware.com -- God loved you so much that He gave His only son Jesus.
In article <v8b1d09b8efaran3m2kt931tf89kd7db6g@4ax.com>,
[quoted text, click to view] Hugo Kornelis <hugo@pe_NO_rFact.in_SPAM_fo> wrote: > Hi Christian, > > Have you checked for upper- and lowercase letters? If the database uses a > case-sensitive collation, the tables employee, Employee, EMPLOYEE and > EmplOyEE are all different. > > Best, Hugo That indeed was the problem. What a waste of my day this has been! Thanks for the help! :D Thanks, Christian pariahware@pariahware.com Pariahware, Inc. Custom Software and Shareware http://www.pariahware.com -- God loved you so much that He gave His only son Jesus.
Is there really a table called employee? Are you in the right database? Who is the owner of that table?
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ [quoted text, click to view] "Christian Miller" <pariahware@pariahware.com> wrote in message news:pariahware-434093.15550916062004@news2-ge0.southeast.rr.com... > Hello. > I received a detached database/log from my client. I attached the > database to my SQLServer 2000 SP3 installation just fine. In the > enterprise manager I can query any table I want. > > However, when I attempt to query a table via the query analyzer, it > always fails, even though I am logged in as the "sa". > Below is my query and the result. I am not having this trouble with any > other database on the system. > > select * from employee > > Below is the error message: > Server: Msg 208, Level 16, State 1, Line 1 > Invalid object name 'employee'. > > Any help would be appreciated. > > Thanks, > Christian > pariahware@pariahware.com > Pariahware, Inc. Custom Software and Shareware > http://www.pariahware.com > -- > God loved you so much that He gave His only son Jesus. > What have you done with God's gift?
[quoted text, click to view]
On Wed, 16 Jun 2004 20:19:44 GMT, Christian Miller wrote: >In article <uwTZNx9UEHA.1048@TK2MSFTNGP09.phx.gbl>, > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> > wrote: > >> Is there really a table called employee? >Yes, I can view it in the enterprise manager. > >> Are you in the right database? >Yes, I've even used the "use" command to make sure, on occassion. > >> Who is the owner of that table? >The owner of the table is "dbo". > >When I look under the db's users, "dbo" is a name entry, "sa" is the >login name and access is "permit". Hi Christian, Have you checked for upper- and lowercase letters? If the database uses a case-sensitive collation, the tables employee, Employee, EMPLOYEE and EmplOyEE are all different. Best, Hugo --
Try:
SELECT * FROM dbname.dbo.employee. Also, the server might be case-sensitive, make sure you use proper case. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ [quoted text, click to view] "Christian Miller" <pariahware@pariahware.com> wrote in message news:pariahware-21E05C.16194316062004@news2-ge0.southeast.rr.com... > In article <uwTZNx9UEHA.1048@TK2MSFTNGP09.phx.gbl>, > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> > wrote: > > > Is there really a table called employee? > Yes, I can view it in the enterprise manager. > > > Are you in the right database? > Yes, I've even used the "use" command to make sure, on occassion. > > > Who is the owner of that table? > The owner of the table is "dbo". > > When I look under the db's users, "dbo" is a name entry, "sa" is the > login name and access is "permit".
Case sensitivity for object names is based on the database collation (if my memory serves me).
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ [quoted text, click to view] "Christian Miller" <pariahware@pariahware.com> wrote in message news:pariahware-11C0F9.16271516062004@news2-ge0.southeast.rr.com... > In article > <pariahware-21E05C.16194316062004@news2-ge0.southeast.rr.com>, > Christian Miller <pariahware@pariahware.com> wrote: > > > In article <uwTZNx9UEHA.1048@TK2MSFTNGP09.phx.gbl>, > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> > > wrote: > > > > > Is there really a table called employee? > > Yes, I can view it in the enterprise manager. > > > > > Are you in the right database? > > Yes, I've even used the "use" command to make sure, on occassion. > > > > > Who is the owner of that table? > > The owner of the table is "dbo". > > > > When I look under the db's users, "dbo" is a name entry, "sa" is the > > login name and access is "permit". > > OK, apparently there is not a database table called "employee", but > there is one called "EMPLOYEE". I don't ever remember table name case > being an issue when performing a querying before. I normally uppercase > key words and lowercase table names. Is this a setting in my SQL Server > that I accidentally set? > > > Thanks, > Christian > pariahware@pariahware.com > Pariahware, Inc. Custom Software and Shareware > http://www.pariahware.com > -- > God loved you so much that He gave His only son Jesus. > What have you done with God's gift?
In article <u2N$QN#UEHA.2920@TK2MSFTNGP10.phx.gbl>,
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> [quoted text, click to view] wrote: > Case sensitivity for object names is based on the database collation (if my > memory serves me). If that per database file or per server? How would I turn off database collation if I wanted to? I really appreciate all the help on this. Thanks, Christian pariahware@pariahware.com Pariahware, Inc. Custom Software and Shareware http://www.pariahware.com -- God loved you so much that He gave His only son Jesus.
It is a database setting.
use alter database collate SQL_Latin1_General_CP1_CI_AI to make it case insensitive. The collation settings are usually set at the time of setup. Regards Partha Mandayam Software Consultant Home page: http://partha.tripod.com *** Sent via Devdex http://www.devdex.com ***
Try sp_helpsort to determine the the sort order.
[quoted text, click to view] "Christian Miller" <pariahware@pariahware.com> wrote in message news:pariahware-434093.15550916062004@news2-ge0.southeast.rr.com... > Hello. > I received a detached database/log from my client. I attached the > database to my SQLServer 2000 SP3 installation just fine. In the > enterprise manager I can query any table I want. > > However, when I attempt to query a table via the query analyzer, it > always fails, even though I am logged in as the "sa". > Below is my query and the result. I am not having this trouble with any > other database on the system. > > select * from employee > > Below is the error message: > Server: Msg 208, Level 16, State 1, Line 1 > Invalid object name 'employee'. > > Any help would be appreciated. > > Thanks, > Christian > pariahware@pariahware.com > Pariahware, Inc. Custom Software and Shareware > http://www.pariahware.com > -- > God loved you so much that He gave His only son Jesus. > What have you done with God's gift?
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
| home · blog · groups | Questions? Comments? Contact the dn |