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.
SAP Knowledge Base Article - Preview