code_junkie

Deploying WCF Client assembly in SQL2005

Nov 13th, 2011
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. CREATE ASSEMBLY System_Runtime_Serialization FROM 'C:WindowsMicrosoft.NETFrameworkv3.0Windows Communication FoundationSystem.Runtime.Serialization.dll'
  2. WITH PERMISSION_SET = UNSAFE
  3. GO
  4.  
  5. CREATE ASSEMBLY System_Web FROM 'C:WindowsMicrosoft.NETFrameworkv2.0.50727System.Web.dll'
  6. WITH PERMISSION_SET = UNSAFE
  7. GO
  8.  
  9.  
  10. CREATE ASSEMBLY System_ServiceModel FROM 'C:WindowsMicrosoft.NETFrameworkv3.0Windows Communication FoundationSystem.ServiceModel.dll'
  11. WITH PERMISSION_SET = UNSAFE
  12. GO
  13.  
  14. Assembly 'System.Web' references assembly 'system.web, version=2.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: version, culture or public key mismatch). Please load the referenced assembly into the current database and retry your request.
  15.  
  16. CREATE ASSEMBLY System_Runtime_Serialization FROM 'C:WindowsMicrosoft.NETFrameworkv3.0Windows Communication FoundationSystem.Runtime.Serialization.dll'
  17. WITH PERMISSION_SET = UNSAFE
  18. GO
  19.  
  20. CREATE ASSEMBLY System_Web FROM 'C:WindowsMicrosoft.NETFramework64v2.0.50727System.Web.dll'
  21. WITH PERMISSION_SET = UNSAFE
  22. GO
  23.  
  24. CREATE ASSEMBLY System_IdentityModel FROM 'c:Program FilesReference AssembliesMicrosoftFrameworkv3.0System.IdentityModel.dll'
  25. WITH PERMISSION_SET = UNSAFE
  26. GO
  27. CREATE ASSEMBLY System_IdentityModel_Selectors FROM 'c:Program FilesReference AssembliesMicrosoftFrameworkv3.0System.IdentityModel.Selectors.dll'
  28. WITH PERMISSION_SET = UNSAFE
  29. GO
  30.  
  31. CREATE ASSEMBLY System_Messaging FROM 'c:windowsMicrosoft.netFrameworkv2.0.50727System.Messaging.dll'
  32. WITH PERMISSION_SET = UNSAFE
  33. GO
  34.  
  35. CREATE ASSEMBLY System_ServiceModel FROM 'C:WindowsMicrosoft.NETFrameworkv3.0Windows Communication FoundationSystem.ServiceModel.dll'
  36. WITH PERMISSION_SET = UNSAFE
  37. GO
Add Comment
Please, Sign In to add comment