We have sql2005 64 bit and framework 2.0  32 and 64 bit.

When i try to deploy a UDF 64 bit assembly via vs.net2005 i get following error.

Error: Attempted to load a 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead if trying to load for reflection purposes.

Does any one know how to find whether sql is using 32 bit or 64 bit frame work. or there is a workaround

tia.

getting dates between start date and end date
how to optimize this procedure
Oracle "Dual" table equivalent in SQL Server
Conditional Where Clause
FORCEPLAN causes different results in SQL SERVER 2000