Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

URGENT: Error executing scripts...... Expand / Collapse
Author
Message
Posted Thursday, January 24, 2008 8:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 10, 2014 12:57 PM
Points: 186, Visits: 805
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 ;)


  Post Attachments 
VORTAL SQLBrokerServicesScript.zip (6 views, 5.39 KB)
Post #446957
Posted Thursday, January 24, 2008 12:00 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, September 14, 2009 1:59 PM
Points: 516, Visits: 425
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.

Post #447132
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse