InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 05:59:21 GMT20http://www.sqlservercentral.com/Forums/Topic973403-146-1.aspxNavigate to SQL Server Agent --> Alerts. Right Click and select New Alert. In the new alert enter the Error Number and in response select "Notify Operators"Mon, 23 Aug 2010 09:30:21 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic973403-146-1.aspxHello,Our system is having a sudden trust of certain applications that is causing the Server memory load. and in some cases few of the commands are erroring out with the error which is getting captured in the SQL logs:701 : insufficent memory to execute this statement. For this i need to configure a alert that will fire a mail when this memory issue is popping up. I already have the DBmail set up on this server.Any pointers to this issue is required urgently.Thanks,AmitMon, 23 Aug 2010 06:57:32 GMTamitghosh83