When I use SQL 2005 CLR , it show error message--
.NET Framework execution was aborted by escalation policy because of out of memory.
My machine is Window 2003 server sp1, SQL2005 server standard version 9.0.2153.
My data about 500,000 row , use C# to deal with business logic(include DataTable.Bulk copy to SQL 2005)
PS. if the data around 200,000 is OK. But when memory usage is grow ,the error message still will happen .
Question1: How can I take care the error message?
Question2: How can I release memory in SQL 2005 server?
Please help! Thanks..
.NET Framework execution was aborted by escalation policy because of out of memory.
My machine is Window 2003 server sp1, SQL2005 server standard version 9.0.2153.
My data about 500,000 row , use C# to deal with business logic(include DataTable.Bulk copy to SQL 2005)
PS. if the data around 200,000 is OK. But when memory usage is grow ,the error message still will happen .
Question1: How can I take care the error message?
Question2: How can I release memory in SQL 2005 server?
Please help! Thanks..