+ Reply to Thread
Results 1 to 2 of 2

How to copy all SQL logins without copying a database?

  1. 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

  2. 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




+ Reply to Thread