quote:
why notselect * from syslogins
syslogins doesn't contain the password. I believe you could do something like the following, but I wouldn't mess with it as long as there are easier ways.
On source server:
DECLARE @binpwd sysname,
@sidid binary(16)
select @binpwd = a.password,
@sidid = a.sid
from sysxlogins a,
syslogins b
where a.sid = b.sid
and b.name = '[name]'
On destination server:
EXEC sp_addlogin '[name]',
@passwd= @binpwd,
@defdb = 'Master',
@deflanguage = 'us_english',
@sid = @binsid,
@encryptopt = 'skip_encryption'