Finally I had a time to make a second update to my post Querying Active Directory on SQL Server using CLR. This update should finally resolve an issue when you need to return large numbers of properties from Active Directory.
The solution is very simple by adding a possibility to specify the columns lengths (maximum length) for the returned properties. All the structures in the code left the same as they were originally. The only change is, that the list of properties is no longer passed as a comma separated list and now semicolon is used to delimit the properties. Comma can be used to provide a column length. If the length is not provided then the default of 4000 is used as it was before.
So don’t hesitate and check the updated article.
I’ve also provided a link to an updated Visual C# project with all the codes.
Pavel's SQL Pages 
hi, how to define the column lenght in sql query, to get the larger property content (larger than 4000). I found you solved it by using CLR. Can it possible in sql query(openquery)?
thanks.
Hi,
don’t know whether it is possible.. Right now don’t have possibility to test, but will try to take a look during next week.