Viewing 2 posts - 1 through 2 (of 2 total)
Try:
SELECT original_login_name, *
FROM sys.dm_exec_sessions
where login_name = 'S-1-9-3-322691058-1310504681-3474585482-2036716736'
I got the same issue, but do not know how to fix it so SQL Server shows the correct login name or SID....
September 6, 2013 at 1:15 pm
Run this on the source SQL Server as text output:
select 'DTUTIL /SQL "'+f.foldername+'"/"'+ name +'" /DestServer [YOURSQLSERVERDEST] /COPY SQL;"'+f.foldername+'"/"'+name+'" /QUIET' from msdb.dbo.sysssispackages p
inner join msdb.dbo.sysssispackagefolders f
on p.folderid = f.folderid
Then modify...
September 19, 2011 at 12:03 pm
Viewing 2 posts - 1 through 2 (of 2 total)