URGENT: Error executing scripts......

• JMSM

  SSCertifiable

  Points: 5440

  More actions

  January 24, 2008 at 8:30 am

  #121904

  Good afternoon,

  The following errors are reported after executing one script that i send u attached to this post one .zip file with reports and .sql that were executed.

  1.Code:

  USE econstroi2

  GO

  IF NOT EXISTS (SELECT * FROM sys.assemblies WHERE name = 'System.Web')

  CREATE ASSEMBLY [System.Web]

  AUTHORIZATION extLogin

  FROM 'C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Web.dll'

  WITH PERMISSION_SET=UNSAFE;

  Error - Report_Script_System.Web_20080124.txt;

  2.Code:

  USE econstroi2

  GO

  IF NOT EXISTS (SELECT * FROM sys.assemblies WHERE name = 'System.IdentityModel')

  CREATE ASSEMBLY [System.IdentityModel]

  AUTHORIZATION extLogin

  FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0\System.IdentityModel.dll'

  WITH PERMISSION_SET=UNSAFE;

  Error - Report_Script_System.IdentityModel_20080124.txt;

  3.Code:

  USE econstroi2

  GO

  IF NOT EXISTS (SELECT * FROM sys.assemblies WHERE name = 'System.IdentityModel.Selectors')

  CREATE ASSEMBLY [System.IdentityModel.Selectors]

  AUTHORIZATION extLogin

  FROM 'C:\Program Files\Reference Assemblies\Microsoft\Framework\v3.0\System.IdentityModel.Selectors.dll'

  WITH PERMISSION_SET=UNSAFE;

  Error - Report_Script_System.IdentityModel.Selectors_20080124.txt;

  4.Code:

  USE econstroi2

  GO

  IF NOT EXISTS (SELECT * FROM sys.assemblies WHERE name = 'System.ServiceModel')

  CREATE ASSEMBLY [System.ServiceModel]

  AUTHORIZATION extLogin

  FROM 'C:\WINDOWS\Microsoft.NET\Framework\v3.0\Windows Communication Foundation\System.ServiceModel.dll'

  WITH PERMISSION_SET=UNSAFE;

  Error - Report_Script_System.ServiceModel_20080124.txt;

  5.Code:

  USE econstroi2

  GO

  IF NOT EXISTS (SELECT * FROM sys.assemblies WHERE name = 'Microsoft.Transactions.Bridge')

  CREATE ASSEMBLY [Microsoft.Transactions.Bridge]

  AUTHORIZATION extLogin

  FROM 'C:\Windows\Microsoft.NET\Framework\v3.0\Windows Communication Foundation\Microsoft.Transactions.Bridge.dll'

  WITH PERMISSION_SET=UNSAFE;

  Error - Report_Script_Microsoft.Transactions.Bridge_20080124.txt;

  Thanks and regards,

  Jorge 😉

• jsheldon

  SSCertifiable

  Points: 5250

  More actions

  January 24, 2008 at 12:00 pm

  #771447

  Cannot see your attachment.

  Please open SQL Books online and in the search enter CREATE ASSEMBLY

  Read up on the syntax when using this command, this should point you in the right direction.