SQL Server 2005: An example of writing a CLR function that wraps the LookupAccountSid WinAPI call

SQL Server 2005: An example of writing a CLR function that wraps the LookupAccountSid WinAPI callhttp://blogs.msdn.com/lcris/archive/2005/09/26/474202.aspxI was looking recently into writing a wrapper for the LookupAccountSid WinAPI function, so that I could use this functionality in T-SQL. I decided to write a CLR function and document the steps here: 1. First, we need to write the code into a file - Ien-USCommunityServer 2.1 SP1 (Build: 61025.2)re: SQL Server 2005: An example of writing a CLR function that wraps the LookupAccountSid WinAPI callhttp://blogs.msdn.com/lcris/archive/2005/09/26/474202.aspx#702968Wed, 16 Aug 2006 23:20:54 GMT91d46819-8472-40ad-a661-2c78acb4018c:702968Mike CatoThanks for the LookupNameSid example.  There was a gap between examples in Allen Jones' "C# Programmer's Cookbook", MSDN examples and reality.  You filled the gap.