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 |
|
r_sonakiya
Starting Member
25 Posts |
 Posted - 2001-12-03 : 10:56:16
|
| When moving database from one physical server to other using any of the following method never brings the Login/users associated to them.1. dbattach method2. Transferring all object using GENERATE SQL SCRIPTS FOR ALL OBJECTS3. BACKUP & RESTORE MethosAny one knows how the Logins can be transferrd successfully.Thanks,Ravi |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-12-03 : 12:02:48
|
| logins are used to gain access to the server and so are not specific to a database. They are held in master and map to users in a database. Note that when you transfer a database the users may map to a logon ID but this won't necessarily (or usually) be the same login as on the source server.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
r_sonakiya
Starting Member
25 Posts |
Posted - 2001-12-03 : 14:40:53
|
| Hello NR,So we need to create the Login(s) again if you transfer SQLServer Database from one Server to another.Is there any other way of handling this situation.Thanks,Ravi |
|
|
|
shankarc
Starting Member
37 Posts |
|
|
|
|
|
Login Transfer