Symptom
After loading a database dump to new database, some tables cannot be selected correctly, even the table name can be found in the table sysobjects.
Error message below can be found:
select * from sample_table
go
Msg 208, Level 16, State 1:
Server 'test_server', Line 1:
sample_table not found. Specify owner.objectname or use sp_help to check whether the
object exists (sp_help may produce lots of output).
Mismatch can be found from sp_helpuser, in this case, the login_name should be the 'test' but not 'Non_test'
1> sp_helpuser
2> go
Users_name ID_in_db Group_name Login_name
--------------- --------------- ---------------- ---------------------
test 3 public Non_test
usedb_user 4 public NULL
(1 row affected)
(return status = 0)
Read more...
Environment
Product
Keywords
Msg 208, sp_helpuser , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.