Monday, February 20, 2012

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
JPScript 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

No comments:

Post a Comment