Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
sql server issue
Hi, I have done all the for above attached issue.
see below sql scripts for used for the issue. I have restrated the server the server already after scripts.
SELECT 'TEST' AS Test EXECUTE AS USER = 'dbo'
EXEC sp_changedbowner 'sa'
ALTER DATABASE [Company DB] SET TRUSTWORTHY ON
ALTER AUTHORIZATION ON DATABASE::[Company DB] TO sa;
USE [Company DB];
EXEC sp_configure 'clr enabled' ,1
GO
RECONFIGURE
GO
EXEC sp_configure 'clr enabled' -- make sure it took
GO
But still getting same error message (See attached)
image006.jpg
see below sql scripts for used for the issue. I have restrated the server the server already after scripts.
SELECT 'TEST' AS Test EXECUTE AS USER = 'dbo'
EXEC sp_changedbowner 'sa'
ALTER DATABASE [Company DB] SET TRUSTWORTHY ON
ALTER AUTHORIZATION ON DATABASE::[Company DB] TO sa;
USE [Company DB];
EXEC sp_configure 'clr enabled' ,1
GO
RECONFIGURE
GO
EXEC sp_configure 'clr enabled' -- make sure it took
GO
But still getting same error message (See attached)
image006.jpg
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
so you think
USE [Company DB];
EXEC sp_configure 'clr enabled' ,1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'clr enabled' -- make sure it took
GO
USE [Company DB];
EXEC sp_configure 'clr enabled' ,1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'clr enabled' -- make sure it took
GO
I'm not sure what you're trying to do (you didn't provide the code line that raised the error) but the RECONFIGURE command needs the WITH OVERRIDE to get the changes applied immediately.
yes , try this also not working same issue
USE [Company DB];
EXEC sp_configure 'clr enabled' ,1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'clr enabled' -- make sure it took
GO
USE [Company DB];
EXEC sp_configure 'clr enabled' ,1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'clr enabled' -- make sure it took
GO
Error is i have attachedYes, I saw it but that's the error message. We need to know the line of code that raised the error so we can try to fix it.
this not coming of from any code,this coming when user trying to enter new records.
for example
INSERT INTO test1 (name) Values('1111')
for example
INSERT INTO test1 (name) Values('1111')
That's weird because there's no CLR call in your example. I'm expecting a stored procedure call instead of a simple INSERT command.
Hi, This is Assembly
CREATE ASSEMBLY [TimeZone]
AUTHORIZATION [dbo]
FROM 0x4D5A90000300000004000000
WITH PERMISSION_SET = EXTERNAL_ACCESS
GO
AND Function
CREATE FUNCTION [dbo].[TimeZoneConvert](@i
RETURNS [datetime] WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [TimeZone].[UserDefinedFun
GO
CREATE ASSEMBLY [TimeZone]
AUTHORIZATION [dbo]
FROM 0x4D5A90000300000004000000
WITH PERMISSION_SET = EXTERNAL_ACCESS
GO
AND Function
CREATE FUNCTION [dbo].[TimeZoneConvert](@i
RETURNS [datetime] WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [TimeZone].[UserDefinedFun
GO
You're creating an assembly from an assembly bits. I'm not sure how that behaves when you're migrating it.
I would expect a reference to a .dll file so you can also migrate the file.
I would expect a reference to a .dll file so you can also migrate the file.
I think that's why you're getting those bits. Try to contact the vendor to know which .dll file is needed or see if this article helps you (you'll need Visual Studio to run the presented code).
Premium Content
You need an Expert Office subscription to comment.Start Free Trial