Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dollysheep
Starting Member
2 Posts |
 Posted - 2006-05-27 : 06:02:55
|
userA is a SQL server account. server A and server B is same, server A is to serve live operation. And server B for backup.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 ?   |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-27 : 06:30:00
|
| because you overwritten whatever settings there is on serverB from serverA--------------------keeping it simple... |
 |
|
|
dollysheep
Starting Member
2 Posts |
Posted - 2006-05-27 : 10:32:14
|
quote:
Originally posted by jen
because you overwritten whatever settings there is on serverB from serverA--------------------keeping it simple...
I just copy the the .MDf and .LDF  |
|
|
|
|
|
|
database access problem