Today I was working on hooking up some CLR sprocs in SQL Server. My friend Greg Low (SolidQ Australia) pointed out that even vb clr sprocs are case sensitive.
I loaded an assembly like so:
CREATE ASSEMBLY AuditingSPROCS from 'C:\Development\AuditingSPROCS.dll' WITH PERMISSION_SET = SAFE
Now for the fun. I had to tweak this a bit. The items in [] below are the namespace and class name. That is followed by a . and the sproc name:
CREATE PROCEDURE SelectReportsAll AS
EXTERNAL NAME AuditingSPROCS .[Auditing.StoredProcedures.Sprocs].SelectReportsAll
And you can test it like so:
exec SelectReportsAll
And this tidbit from my good friend Andrew Brust shows how to get details of the CLR installation on SQL Server. Guess what? 2008 is using CLR with .Net 2.0. Weird.
select * from sys.dm_clr_properties