Hi, My query returns only one row. estimated row size is 5478. All other queries run fine but this particular query is throwing System.OutOfMemoryException. When does SQL server throw this error for a particular query only? This is the query which is throwing error System.OutOf Memory exception SELECT * FROM MemberDetail MD INNER JOIN Users ON Users.g_User_Id=MD.g_User_Id WHERE Users.u_logon_name='anna' Environment is .Net and SQL Server http://weblogs.asp.net/pleloup/archive/2004/04/01/105492.aspx Please help!