CLR procedures for SQL Express with VB Express

Hello,

Does anyone know if is it possible to create CLR procedures for SQL Express with VB Express?

Regards,

hi,

AFAIK, yes, it is, you only have to deploy them "by hand"..

regards

|||

Hi,

Do you have details how to do that? I'm new to SQL 2005 and I can only find information about creating CLR procedures pointing to Visual Studio Database Project, which is not available on the Express version.

Thanks

|||

hi,

Gustavo Bilinski wrote:

Do you have details how to do that? I'm new to SQL 2005 and I can only find information about creating CLR procedures pointing to Visual Studio Database Project, which is not available on the Express version.

Thanks

yes, only VS professional or higher provides the SQL CLR template you can start from, but even Express editions should be able to write them... of course you should implement the skeleton your self as, again, only Professional or higher editions provide it.. you have to imports specific Namespaces, and declare specific attributes for class members and methods.. but when you're finished, the reuslt is actually the same..

regards