Export many users to new database

17 Feb 2006 8:13 PM

AkAlan

Is there a system stored procedure or other method for mass exporting all
users from one database to another on the same server?

17 Feb 2006 10:35 PM

Anith Sen

You can use Generate SQL script option to create a script of all the users
in a database ( look in the third table in the interface )& then simply
execute the script in the second database.

--
Anith

18 Feb 2006 7:03 PM

AkAlan

Thanks for yuor reply. I know how to script objects like tables and views but
how do you script users?

Show quote

"Anith Sen" wrote:

> You can use Generate SQL script option to create a script of all the users
> in a database ( look in the third table in the interface )& then simply
> execute the script in the second database.
>
> --
> Anith
>
>
>

18 Feb 2006 7:37 PM

AkAlan

Never Mind, I got it. Had to go to Enterprise Manager and select the database
with the users I wanted to move then go to Tools_Generate SQL Script... the
select the options tab which then gives me the option to script users. Works
great.

Show quote

"AkAlan" wrote:

> Thanks for yuor reply. I know how to script objects like tables and views but
> how do you script users?
>
> "Anith Sen" wrote:
>
> > You can use Generate SQL script option to create a script of all the users
> > in a database ( look in the third table in the interface )& then simply
> > execute the script in the second database.
> >
> > --
> > Anith
> >
> >
> >