I am trying to create an assembly on my SQL Server 2005 server. Here is what I am using:
CREATE ASSEMBLY [SQLCLRTest]
AUTHORIZATION [dbo]
FROM 'path\to\my\file.dll'
WITH PERMISSION_SET = EXTERNAL_ACCESS;
I am getting this error as ouput:
Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
When I look at my error logs I find the following in the stack trace:
Exception Log - EXCEPTION_ACCESS_VIOLATION
I've been Googling around and the only solution I have seen to this is to change the database owner, which is not an option for me. I'm thinking that I need to have some sort of permissions set for my user but I can't find exactly what I need.
Could anyone give me some advice on how to handle this? It would be very much appreciated.
Thanks!
Edit The version of SQL Server:
Microsoft SQL Server 2005 - 9.00.5057.00 (X64)
PERMISSION_SET = UNSAFE? – Thomas Stringer Jul 31 '12 at 14:21SELECT @@VERSION;)? Most access violations are bugs, and most get fixed. It's quite possible that refreshing your installation will magically fix this... – Aaron Bertrand Jul 31 '12 at 15:07