Comments posted to this topic are about the item Stairway to SQLCLR Level 5: Development (Using .NET within SQL Server)

SQL# - http://www.SQLsharp.com/

I have never seen all of this written out so concisely before, thank you for the hard work that's gone into this.

---

Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.

Hi Phil. You are quite welcome. And thank you, not just for being complimentary, but also for this specific compliment. It helps validate my perception that this information, while being terribly important to know, has not been made readily available / accessible. Yet this is what anyone doing SQLCLR work eventually runs into, but usually only after trial and error and then, if they can even find any information on a particular issue, it is uncertain whether it is truly useful or just misinformation. Hence my trying to improve that situation :-).

Thanks again and take care,
Solomon...

SQL# - http://www.SQLsharp.com/

Solomon, you know I'm already a fan, but wow!! I agree with Phil, this article is completely unique across the internet. Anybody considering SQL CLR development should start with your Stairway and this article will be invaluable.

---

David

David, thank you very much. I (and my wife ;-) ) greatly appreciate hearing that the time and effort spent on gathering the info, organizing it, writing it up, coming up with representative examples, testing those, etc is fulfilling the intention of providing help and clarity to hopefully improve the quality of SQLCLR projects.

Thanks and take care,
Solomon...

SQL# - http://www.SQLsharp.com/

Really love this SQLCLR series. Many thanks Solomon for your hard-work.

Hi Jeffrey. You are quite welcome. And thank you for sharing that :-).

Take care,
Solomon..

SQL# - http://www.SQLsharp.com/

Great job Solomon. Many advanced topics not found anywhere else.
Thus, I've not found a solution to my problem.
I would like to manage windows local groups on server through SQLCLR. I deploy my signed assembly using asymmetric key, login with this key, setting UNSAFE...
I added the .net assemblies : System.DirectoryServices.
My C# code works perfectly in console logged as administrator.
The same code in stored procedures, with impersonnation, always give me "Access Denied"
Any ideas to solve that?
Thanks.

Rather than hijacking this thread, I suggest you start another.

---

Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.

Hi,
Is there any possibility of the "The .NET Environment" table being updated to through SQL Server 2016 (and maybe even 2017)?

Sincerely,
Daniel