Owner Name with Table

[Zahir]

I am using SQLSERVER 7.00 i am having a trouble that in every query i must give the Owner name with my Table name Other wise query cant excute and message return <br>
<br>
Invalid Object<br>
<br>
<br>
e.g.<br>
<br>
select * from [Owner].Employee<br>

 

[calahans]

Zahir,<br>
<br>
Are you logged in as 'sa' (system administrator). If you don't get the error when logged in as 'sa' then it is probably a permissions problem. Check the permissions for your current user and make sure you have SELECT rights on the table you are querying.<br>
<br>
Saying that the error you are getting seems a bit strange.<br>
<br>
Let me know how you get on.<br>
<br>
C

 

[Madsam]

If the table (or any SQL Server object, like a stored procedure or view) was created by someone OTHER than the DBO (database owner), you have to specify the dbo name if it's someone other than the person logged on.<br>
<br>
For our production environment, we always create the objects as the SA, who is also the dbo. With that method, you can disregard the second qualifier and access the object directly.<br>
<br>
Regards...