Home Forums SQL Server 7,2000 T-SQL Getting SID from Active Directory - SID transformation problems RE: Getting SID from Active Directory - SID transformation problems
jorge escobar pacheco
SSC-Addicted
Points: 421
More actions
June 24, 2009 at 3:00 pm
#1014953
Sure:
at ufnHEXtoSID after this:
set @res = substring(@hexNumbBIN, @step,1)
select @AuxChar = dbo.BINtoASCIItoHEX(ascii(@res))
set @auxchar = isnull(@auxchar, '')
add this:
if len(@auxchar)= 1
set @auxchar = '0' + @auxchar
Regards