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,

[132 byte] By [GustavoBilinski] at [2007-12-22]
# 1

hi,

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

regards

AndreaMontanari at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Express...
# 2

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

GustavoBilinski at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Express...
# 3

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

AndreaMontanari at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Express...

SQL Server

Site Classified