Search code examples
sql-serversql-server-2008-r2sqlclr

CLR stored procedure is automatically encrypted


I have created a simple CLR procedure that creates a Folder. The problem is that each time I create the procedure inside SQL Server using the "CREATE PROCEDURE..." statement, the procedure is automatically encrypted. I am not using the WITH ENCRYPTION clause and I am also aware that it cannot be used for CLR objects so I am confused here. Here is my code:

CREATE PROCEDURE CreateFolder(@Path nvarchar(500), @FolderName nvarchar(50), @ReturnCode int output, @ReturnMessage nvarchar(500) output )
WITH EXECUTE AS OWNER 
AS
EXTERNAL NAME MyLibrary.[MyLibrary.StoredProcedures].CreateFolder
GO

I am using SQL Server 2008 R2 workgroup edition.

This is the screenshot

Any help is much appreciated.

Thank you.


Solution

  • Is it just showing it as encrypted because you can't see the code for it in Management Studio? You can't script to ALTER or anything so that is likely why.