Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
vishalchowdhary
Starting Member
9 Posts |
Posted - 2008-08-28 : 20:54:39
|
Hi, I'm having a problem with querying a table from a database.My query is as simple as select * from coll_setup.This same query used to work earlier but today it gave me the Msg 208 error. I do understand that this error signifies that the table is not a part of the database. But it surely is and I can view the table data by right clicking on the table under MS SQL Server Management Studio and selecting open table.I tried select * from information_schema.tables and coll_setup does'nt show in the listing.Pls help.Thanks,Vishal |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-28 : 22:26:28
|
Have you tried: select * from ObjectOwner.coll_setup? Who owns the object, dbo?Are you sure you are looking in the right database?How about this:USE SomeDatabaseGOSELECT * FROM ObjectOwner.coll_setupTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
vishalchowdhary
Starting Member
9 Posts |
Posted - 2008-08-29 : 12:26:01
|
Hey Tara, It worked when I execute Use <DB>.But I still don't understand how my settings changed and the problem occured in the first place. I was able to work on this database until day before yest. Can you plz explain that?Thanks,Vishal |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
vishalchowdhary
Starting Member
9 Posts |
Posted - 2008-08-29 : 13:44:08
|
Thanks Tara. |
|
|
|
|
|