Database export

Hi
When exporting a database from one server to another is
it then somehow possible to make sure that both the users
in the database and the server logins are being exported
too.
It seems that only the users in the database are being
exported. I know that you afterwards can use sp_addlogin
and sp_change_users_login. But this will force one to
change the existing passwords.
TIA
Klaus
I suggest you search KB for sp_help_revlogins.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Klaus" <anonymous@.discussions.microsoft.com> wrote in message
news:067301c49188$fe271350$a401280a@.phx.gbl...
> Hi
> When exporting a database from one server to another is
> it then somehow possible to make sure that both the users
> in the database and the server logins are being exported
> too.
> It seems that only the users in the database are being
> exported. I know that you afterwards can use sp_addlogin
> and sp_change_users_login. But this will force one to
> change the existing passwords.
> TIA
> Klaus
|||Klaus
Here a links to a lot of articles which will give you help when moving
databases between servers.
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission Issues
When a Database Is Moved Between SQL Servers
Hope this helps
John
|||Thanks for your answer, Tibor.
This may be a stupid question but what is KB. The online
books don't seem to say anything about sp_help_revlogins.
-- Klaus

>--Original Message--
>I suggest you search KB for sp_help_revlogins.
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"Klaus" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:067301c49188$fe271350$a401280a@.phx.gbl...
users[vbcol=seagreen]
exported[vbcol=seagreen]
sp_addlogin
>
>.
>
|||KB = Knowledge Base.
Collection of 'How it works' technical descriptions on the
Microsoft web site.
Peter
"Cauliflower is nothing but cabbage with a college
education."
Mark Twain

>--Original Message--
>Thanks for your answer, Tibor.
>This may be a stupid question but what is KB. The online
>books don't seem to say anything about sp_help_revlogins.
>-- Klaus
>
>message
>users
>exported
>sp_addlogin
>.
>