-
How to copy all SQL logins without copying a database?
Is there a way to copy all SQL logins from one SQL 2005 to another, without
copying databases? I already have databases on my warm standby, all I need is
to be able to copy logins on a daily bases.
Thank you in advance,
Leon
-
Re: How to copy all SQL logins without copying a database?
In order of my preference:
SQL Server Integration Services; Transfer Logins Task (Most preferred)
SQL Server Integration Services; Transfer Database Objects Task
SQL Server Management Studio: Script the Login(s) and run the script on the
destination server
"Leon Shargorodsky" wrote in
message news:319588BF-754D-40E3-8360-3170A251D5ED@microsoft.com...
> Is there a way to copy all SQL logins from one SQL 2005 to another,
> without
> copying databases? I already have databases on my warm standby, all I need
> is
> to be able to copy logins on a daily bases.
>
> Thank you in advance,
>
> Leon