Table names in Enterprise Manager 1

[GSMike]

In Enterprise Manager, many tables have the user name after them in parentheses (SQL Server 6.5). These tables that do not have "(dbo)" I cannot run queries against, it says "invalid object name".
I have set the permissions so that "users" and "public" have rights to select, but this seems to have no effect.
Can you help?
Thank you...

 

[Bernadette]

Hi There

I think your problem is the ownership of the tables. If Tom creates a table called "Table1" you must refer to it in your code as Tom.Table1 because it was created by him and he is not a dbo. So what you need to do is to amend the table name in your code to [owner].[tablename]. Only Tom can refer to the table as "Table1" because he created it himself.

Hope This Helps
Good Luck
Bernadette X-)