URGENT: Error executing scripts......

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » URGENT: Error executing scripts......

URGENT: Error executing scripts......

Rate Topic

Display Mode

Topic Options

Author

Message

JMSM

Posted Thursday, January 24, 2008 8:30 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:03 AM
Points: 185, Visits: 751

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

jsheldon

Posted Thursday, January 24, 2008 12:00 PM

Mr 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 »

Permissions