1).i create a application in the .net
2).i create a assembly for that application
3).i create a stored procedure to call funcation in the .net
it is working fine for two month.after that i got an error info value .i change the temp and tmp path in sql server.from that time i cannot execute the procedure.i recreate the assembly it give me an error that memeory is not enougth.i increase the size of the database also.i think create successfully but this error is coming when i execute the procedure.
SQL CODE:-
USE [RMS]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[sendSMSLaneDomesticSMS]
@number [nvarchar](200),
@msg [nvarchar](max),
@SMSError [nvarchar](max) OUTPUT
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [RMSDOTNET].[RMSDOTNET.RMSSMSClient].[sendSMSLaneDomesticSMS]
GO
ERROR
System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 209.105.227.19:80
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.GetResponse()
at RMSDOTNET.RMSSMSClient.SMSGetResponse(String SMS_URL)