auto uncheck the table ownership

I have database called "backoff" at both server A and server B.
Before the copy I set the "userA" have the table ownership.
When I copy the database from A to B, the database is fine.
But the security > logins > "userA" > database access its auto uncheck
the table ownership for me.
Its make me very very trouble, anyone can help me ...ah...ah...helpDo you mean that the 'userA' does not have access to the restored database
on server B? Is this user a SQL Server account (that is, not a Windows
account). Perhaps you need to use sp_change_users_login to link the 'userA'
from the restored database to the same login in the server B.
Hpe this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"kennywcy@.gmail.com" wrote:
> I have database called "backoff" at both server A and server B.
> Before the copy I set the "userA" have the table ownership.
> When I copy the database from A to B, the database is fine.
> But the security > logins > "userA" > database access its auto uncheck
> the table ownership for me.
> Its make me very very trouble, anyone can help me ...ah...ah...help
>|||userA is a SQL server account.
server A and server B is same,
but I copy the server A database to server B
the server B before paste the server A database, I set the userA in
security > logins > "userA" > checked the database access for some
table
but after paste it auto uncheck.
Information --> The userA are owner for some table in the database
Any idea ?|||userA is a SQL server account.
server A and server B is same,
but I copy the server A database to server B
the server B before paste the server A database, I set the userA in
security > logins > "userA" > checked the database access for some
table
but after paste it auto uncheck.
Information --> The userA are owner for some table in the database
Any idea ?