[1] on ASE 12.5.4
select * into tempdb..loginaa16 from master..logins
go
then,use DBAartisan migrate tempdb..loginaa16 to HKCORP(80.17)’s tempdb
[2]on ASE 15.5
insert into master..syslogins and update sa and probe’s password.
sp_configure ‘allow updates’,1
go
delete from master..syslogins where name not in (‘sa’,’probe’)
go
insert into master..syslogins(suid,status,accdate,totcpu,totio,spacelimit,timelimit,resultlimit,dbname,name,password,language,pwdate,audflags,fullname,srvname,logincount,procid,lastlogindate,crdate,locksuid,lockreason,lockdate)
select suid,status,accdate,totcpu,totio,spacelimit,timelimit,resultlimit,dbname,name,password,language,pwdate,audflags,fullname,srvname,logincount,procid,null,null,null,null,null from tempdb..loginaa16 a where not exists (select 1 from master..syslogins b where a.name=b.name)
go
update master..syslogins set password=(select password from tempdb..loginaa16 b where b.name=’probe’) where name=’probe’
go
update master..syslogins set password=(select password from tempdb..loginaa16 b where b.name=’sa’) where name=’sa’
go
drop table tempdb..loginaa16
go
sp_configure ‘allow updates’,0
go
