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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Msg 208...object does not exist <= right!!!

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-04 : 11:15:10
Joe writes "I have a user who created a table: letus_test
I then go into SQL Query analyzer and
run the query:

select * from letus_test

then I get the error:

Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'letus_test'.

Obviously the table exists...and I have permissions to access
this table...so?

We are connecting to the db with nt authorization and his
username appears DOMAIN_NAME/username, how do I references
his name to do a select:

select * from database.username.tablename ???

Thank you in advance for any help."
   

- Advertisement -