Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sujitbatsa
Starting Member
1 Post |
 Posted - 2009-03-02 : 07:51:46
|
| Hello,I am trying to reference external assemble in sql 2005 db. I am sending CREATE Assemble and CREATE proc code.CREATE ASSEMBLY [SqlXmlUtilities] FROM 'D:\OutCast\SqlWcfServiceLibrary1\SqlWcfServiceLibrary1\bin\Debug\SqlWcfServiceLibrary1.dll' WITH PERMISSION_SET = UNSAFEGOcreate proc SqlWCF (@name nvarchar(1000))AS EXTERNAL NAME [SqlXmlUtilities].[SqlWcfServiceLibrary1.SqlService1].GetMessagegoGIVEN ERROR........Msg 6522, Level 16, State 1, Procedure SqlWCF, Line 0A .NET Framework error occurred during execution of user defined routine or aggregate 'SqlWCF': System.Exception: Error while referencing external assembly. Assembly 'D:\OutCast\SqlWcfServiceLibrary1\SqlWcfServiceLibrary1\bin\Debug\WcfServiceLibrary1.dll' doesn't exist.System.Exception: at SqlWcfServiceLibrary1.SqlService1.LoadAssembly(String assemblyName, Boolean throwOnError) at SqlWcfServiceLibrary1.SqlService1.GetMessage(SqlString name)Please guide me as soon as possible.Sujeet |
|
|
|
|
|
Error while referencing external assembly.