June 4, 2009 at 3:36 am
I have tried to create assembly in sql server2005 and following scenario occurs:
1) I got error
Create failed for SqlAssembly 'System.Runtime.Remoting'. (Microsoft.SqlServer.Smo)
Assembly 'system.web, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.' was not found in the SQL
2) So I thought to create assembly system.runtime.remoting first I should create assembly 'system.web' , so I tried to add System.web
then I got error
Create failed for SqlAssembly 'System.Web'. (Microsoft.SqlServer.Smo)
Assembly 'system.enterpriseservices, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.' was not found in the SQL catalog.
3) To solve system.web I tried to add assembly 'system.enterpriseservices' and it gives error
Create failed for SqlAssembly 'System.EnterpriseServices'. (Microsoft.SqlServer.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Assembly 'system.runtime.remoting, version=2.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089.' was not found in the SQL catalog.
I got confused because it created a deadlock to add assemblies.
Please suggest me how to add assembly system.runtime.remoting
June 4, 2009 at 2:27 pm
Remoting is not supported or allowed under SQLCLR. It uses connections that can not be done inside the hosted environment.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply