Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    2

    Unanswered: Moving logins on SQL Server 6.5?

    Hello

    Can anyone provide any tips on moving all system logins from one 6.5 server to another(same database). I tried bulkcopy and the logins are there but log states for each login that "login was scripted with a null password for security reasons". Is there any way to tranfer them through the Database/Object Transfer dialog in Enterprise Manager?

    Thank you
    JP

  2. #2
    Join Date
    Feb 2002
    Posts
    7
    Script the users with something like this (don't know exactly anymore no 6.5 server any more)

    Sysusers


    select 'go sp_adduser '+s1.name+' , ' + s2.name
    from sysusers s1, sysusers s2
    where s1.gid = s2.uid
    and s1.suid > 1 -- no dbo
    and s1.uid * -1 <> s1.gid -- no groups

    And don't forget your sysalternates table (aliases)



    Just copy your results in a query window and execute



    Good luck

    Rosko

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •