Post reply

User details need to transfer

  • December 26, 2010 at 8:41 am

    #388504

    Hi,

    I have doubt,

    How do transfer /backup of user accout details ?

    User Details :- User settings, login settings, etc...

    Thanks & regards

    Satish Saidapur

  • December 26, 2010 at 9:39 am

    #1266325

    You can make use of sp_help_revlogin

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • December 26, 2010 at 10:00 am

    #1266328

    Which version to version ?

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • December 26, 2010 at 1:01 pm

    #1266334

    User info or login info?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 29, 2010 at 12:14 am

    #1267039

    Hi,

    User login one server to another server..... How do i do?

    Thanks & Regards

    Satish Saidapur

  • December 29, 2010 at 12:25 am

    #1267043

    saidapur_satish (12/29/2010)

    Hi,

    User login one server to another server..... How do i do?

    Thanks & Regards

    Satish Saidapur

    roxette (sorry, first thing that came to mind, i know its: how do you do)

    anyways the answer

    http://support.microsoft.com/kb/246133

  • December 29, 2010 at 2:21 am

    #1267057

    saidapur_satish (12/29/2010)

    User login one server to another server..... How do i do?

    Server-level login or database-level user? Which one?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 30, 2010 at 1:54 am

    #1267564

    Hi Gail,

    I need database level login......

    Thanks & Regards

    Satish Saidapur

  • December 30, 2010 at 2:03 am

    #1267567

    There is no such thing as a database-level login.

    Logins are server-wide, stored in the master database and allow connection to the server.

    Users are stored per-database, mapped to logins and have the database-level permissions

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 30, 2010 at 2:34 am

    #1267578

    Hi Gail,

    Thank you, but what shall i do for test server user-login move to 2nd server databases....

    Thanks & Regards

    Satish Saidapur

  • December 30, 2010 at 3:18 am

    #1267593

    If you've copied the databases over, the users will go along, they're in the DB, they're copied with the DB.

    For the logins, the link Marco provided should give you what you need. Be sure to include the SID in the script, otherwise you'll have orphaned logins.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply