Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  .NET Inside SQL Server (2005)  CLR Stored Procedure 2 Send msg to port

Author  Topic  Kranti Starting Member 1 Post Posted - 2009-10-30 : 05:51:53 Hi all , 1. First I wrote a CLR stored Procedure (includes a simple select qry) and deployed it with SQL SERVER 2005 DB , after executing it I got the expected result. 2. Then I added a code , which will send a simple text message to specified IP:Port using socket 3. Then I executed this updated CLR stored procedure again , that leads to give me correct qry output but , no message received at port ..... 4. Can anybody give any hint , why i m not able to receive message at port (I tested same code using simple console app, it sends message to port successfully) 5. Where as if I tried to write to file using this CLR stored procedure : It throws "Security Exception" for file IO Pleas Help , if anybody has any hint