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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-11 : 14:15:13
|
| abc writes "I just restored SQLServer 2000 database test as test_qa database. When you login as "user1" and using the "test_qa" database, submiting a query without the username in front of the table does not work select count (*) from user_employee Server: Msg 208, Level 16, State 1, Line 1 Invalid object name 'individual_user'. If I add the username then it works! select count (*) from user1.user_employee 101 Any idea how to resolve this? " |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-11 : 14:44:03
|
| It is most likely that the user1 login is not mapped to the user1 user.try running sp_change_users_login 'report' in the test_qa DB. Post the results.-Chad |
 |
|
|
|
|
|
General SQL