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 |
snake
Starting Member
2 Posts |
Posted - 2005-08-29 : 23:32:03
|
Hi all,I need a favor .... please help. I am working on migrating from SQL server 7 to SQL server 2000, and I can't use the Copy Database Wizard for some reasons, so I wrote several scripts to do this.1- create databases, just to provide a dummy database2- create logins, I use the script from microsoft to transfer the logins and passwords3- restore databases, i got several databases in the same server4- autofix the login sid mismatch, if any.5- assign default database to loginsup to this moment, everything seems working fine, but when I check the properties in the Enterprise Manager, I found that, [ login(a) has access to 2 db (db1 & db2(default server) ) at source server, after I transfer (a) to destination, and assigning db2 as its default server], login(a) has no information on db1 when I check the property in Enterprise manager, however, login(a) has access and rights at db1, how can I the relation retrievable from Enterprise Manager ? Does anyone get any idea ?Thanks a lot.Felix. |
|
|
|
|
|
|