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

  • 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