| Thread | Last Post | Replies |
|
| CLR proc to access a COM object | 28 Jul 2008 00:15 GMT | 2 |
I need to access a COM object (C++) from a stored proc. the interface is too complicated for SQL so i thought i would write a .net proc as a wrapper for the COM object. I don't see how to add a reference to the COM object. When i pick add reference the only thing i get is the ...
|
| clr safety with native or com calls | 27 Jul 2008 13:54 GMT | 1 |
It was with extended stored procs that if the code that was called crashed then it would bring down Sql. Is the same true if sqlclr calls native or com objects? dan
|
| Problem Using Try catch... | 24 Jul 2008 19:59 GMT | 1 |
Since now I'am trapping my stored procedure errors at my Catch block in .Net code. But my DBA now has insisted to use Try Catch blocks in stored procedures itself... As you would expect the exception is now not raised to .Net as it is handled
|
| To update a clr dll should I drop the assembly? | 02 Jul 2008 06:22 GMT | 2 |
I'm updating by hand a dll containing clr code for Sql 2005 stored procedures. My question is which are the steps needed to update the dll to the new compilation? The file is not locked so I can overwrite the old version with the new one,
|