Execute External Process From CLR Based Stored Procedure

Hi All,

I am trying to create a CLR based stored procedure in C#. When i tried printing simple "Hello" from it, it works fine.
Now requirement is to run an exe file from it. For that i use process.start. But when i try to execute the procedure i get all the security execptions. Can someone please help. Following is the code snippet.
-------------------------------------------------------------------------------------------------------------------------------------------------------------

public partial class StoredProcedures

{

[Microsoft.SqlServer.Server.SqlProcedure]

public static void RunProc(string arg)

{

SqlPipe pipe = SqlContext.Pipe;

pipe.Send("Hello");

Process.Start("E: est.exe");

}

}



CREATE ASSEMBLY [RunProcess]

FROM 'RunProcess.dll'



CREATE PROCEDURE dbo.sqlclr_RunProc

(

@arg nvarchar(1024)

)

AS EXTERNAL NAME [RunProcess].[StoredProcedures].[RunProc]

--------------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks
Sid