Re: No access at sql 2000 DB after restore on an other sql server

flabs (flabs@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
no, i didn't run sp_changedbowner. why must i run the sp ?

the result of SELECT user_name(uid), *
geminiuser issues 341576255 U 5 26 1610620982
64 0 0 2006-08-11
16:02:18.570 0 64 0 U 1 8291 0 2006-08-11
16:02:18.570 0 0 0 0 0 18433 0

i find out, if i run select *
from geminiuser.issues i recieved the right result
run i only issues without geniniuser. before issue i recieved an error.

what happens if i run sp_changeDBowner, sure i think it change the owner
of the db? but some else?

must i change all tables, add prefix geminiuser. in my sql script, i don't
like this.

The simplest is if you run with a user that has geminiuser as its default
schema. On SQL 2000, this means that you should run as geminiuser.

I don't know which login you are logged in as, but this login needs to
map to geminiuser. Note that if the login geminiuser owns the database,
the login geminiuser maps to the user dbo.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.