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 |
|
neo316
Starting Member
2 Posts |
 Posted - 2008-01-23 : 03:12:57
|
| Hello everyoneI have a problem with running a simple select query on sql server 2005. I get the following error. Server: Msg 208, Level 16, State 1, Line 1Invalid object nameHowever the same query works fine when I use the fully qualified name for the table i.e. [schema name].[table name]All my objects are under the tp2 schema (which is the user I use to log on). tp2 is set as the default schema for the user tp2 but yet I am not able to access the tables without using the schema name.Any suggestions ?Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-23 : 03:46:17
|
Are you also the owner or a datareader for the table?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
neo316
Starting Member
2 Posts |
Posted - 2008-01-23 : 04:05:52
|
| Am not 100% sure but this is the same user I used to import the database.Also everything was working fine earlier. Not sure what configuration was changed (if at all) and this problem cropped up.PS Am sorry for the amateurish response but I am sure the problem is something very elementary. |
|
|
|
|
|
|
Problems with schema