SQLCLR (RSS)

SQLCLR

CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user
The new RSS feed is here

If you encounter this

Could not obtain information about Windows NT group/user <MyDomain>/<MyName>, error code 0x5.

When you try and CREATE an ASSEMBLY, you might think well I'm not connected as that user. The user it sqawks about is the database owner.

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/CREATE ASSEMBLY Permissions - Could not obtain information about Windows NT group/user

posted Tuesday, November 28, 2006 11:18 AM by SimonSabin with 0 Comments

Unload app domains when using the SQL CLR

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Unload app domains when using the SQL CLR
The new RSS feed is here

SQL Server has a SQLOS that manages the use of threads and memory, this includes how SQL CLR operates within SQL Server. One of the items it does is manage the app domains used by SQLCLR.

A question was raised about if it was possible to unload appdomains directly, just like you can clear the procedure and data cache. Well the poster actually answered the question him self

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Unload app domains when using the SQL CLR

posted Thursday, September 14, 2006 9:54 PM by SimonSabin with 0 Comments