Previous Thread:   DataTableReader to SqlDataReader

2/28/2006 9:06:58 PM    Re: CREATE ASSEMBLY issue
This is most likely a known issue.  Running this command should fix your  
  
problem:  
  
exec sp_changedbowner '<username of the db attacher, 'sa', or any windows  
  
authenticated login>'  
  
See the thread here for more information:  
  
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=194501&SiteID=1  
  
Steven  
  
"Anatoli Dontsov" <Anatoli@dontsov.com> wrote in message  
  
news:O1fpQpOPGHA.1676@TK2MSFTNGP09.phx.gbl...



2/28/2006 11:40:43 PM    CREATE ASSEMBLY issue
Hi, All!  
  
I have a CSharp assembly (with some WMI.NET calls) which requires  
  
System.Management. How should I load it into SQL2005?  
  
If I try  
  
CREATE ASSEMBLY management from  
  
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\system.management.dll' WITH  
  
PERMISSION_SET = UNSAFE  
  
outputs:  
  
Warning: The Microsoft .Net frameworks assembly 'system.management,  
  
version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a,  
  
processorarchitecture=msil.' you are registering is not fully tested in SQL  
  
Server hosted environment.  
  
Warning: The Microsoft .Net frameworks assembly  
  
'system.configuration.install  
  
Warning: The Microsoft .Net frameworks assembly  
  
'system.runtime.serialization.formatters.soap  
  
Warning: The Microsoft .Net frameworks assembly 'system.windows.forms  
  
Warning: The Microsoft .Net frameworks assembly 'system.drawing  
  
Warning: The Microsoft .Net frameworks assembly 'accessibility  
  
Warning: The Microsoft .Net frameworks assembly 'microsoft.jscript  
  
Warning: The Microsoft .Net frameworks assembly 'microsoft.vsa  
  
Msg 0, Level 11, State 0, Line 0  
  
A severe error occurred on the current command.  The results, if any, should  
  
be discarded.  
  
in log:  
  
SqlDumpExceptionHandler: Process 53 generated fatal exception c0000005  
  
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.  
  
Bye, Anatoli

3/1/2006 11:45:39 PM    Re: CREATE ASSEMBLY issue
"Steven Hemingray [MSFT]" <stevehem@online.microsoft.com> wrote  
  
Yes, that helps. Thanks.  
  
Bye, Anatoli  
  
<skip>