April 4, 2002 at 1:11 am
For test-purposes I have installed a server with SQL Server2000. I have restored a backup on this server of a database used on another server.
In the QueryAnalyser I login with a user called CSC. The tables in the database are owned by this user. When I do 'SELECT * FROM Table, I get the error that the object could not be found. When I do 'SELECT * FROM CSC.Table, I get results.
I know that this has something to do with the owners ship of the database and table. I also did the sp_ChangeDbowner and sp_changeobjectowner on this database and set it to CSC, but still no improvement.
I also checked the SID in the sysusers-table with the SID of the syslogins-table, and they are equal.
Who can help me with this?
Thanks in advance.
Maarten
April 4, 2002 at 5:18 am
dbo is the only understood owener reference. When an object is not owned by dbo you must qualify it by ading the ownername. before the object and it login does not affect this.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply