Creating Extended Stored Procedure Using Vs.net 2005 For Sql2005

Hi,

web searches give no end of how extended stored procedures can only be written in C++ ( or maybe vb also) .



And that extended stored procedures should be abandonded in favour of CLR framework procedures.



And how most articles explain how to convert ESPs to CLR procedures!!!!!



But I need to pass a non-discript block of binary data, extract pieces of data identified by its offset into the block, data type inferred by offset; into data to be written to the SQL database. These offsets are determinede by mapping (C UNION) to C typedef structures.



This cannot be done by managed code, therefore cannot be done by C++ CLR.



It is also ill suited for C# .



Sounds like a job for C++ extended stored procedure.



But how does one create and deploy an ESP with Visual Studio 2005? All wizards seem to insist on CLR.



Help!?



Boyd