Any idea to fix this issue?

Error 701 There is insufficient system memory to run this query? never dealt with this before. :confused: even researched how to fix it yet the answers given did nothing... Notice this is occuring when i inject any item.sql from item.sdatas.

Can you post the whole SQL error thingy? :)

Quote:

Originally Posted by Nubness's-Son Can you post the whole SQL error thingy? :)

Quote:

Originally Posted by ＼(＾O＾)／ Error 701 There is insufficient system memory to run this query

Sadly i have already that was the issue right there in the first sentence yet alone that when i check the data that has been executed it's blank..

Quote:

Originally Posted by ＼(＾O＾)／ Error 701 There is insufficient system memory to run this query

uhm sry am im the only one that sees the full error in the error report? <.<
obviously ur ram of u pc/vps is not big enough to handle the situation. U would need atleast 2gb ram to run sql propper.

Quote:

Originally Posted by TeddyBear94 uhm sry am im the only one that sees the full error in the error report? <.< obviously ur ram of u pc/vps is not big enough to handle the situation. U would need atleast 2gb ram to run sql propper.

Sadly it has 3gb of ram and page file has 3gb also.. that is what i do not understand...

You'r SQL cant run on that PC/Host... so yeah ^_^

Quote:

Originally Posted by Nubness's-Son You'r SQL cant run on that PC/Host... so yeah ^_^

Sadly enough it was working perfectly fine, yet out of the blue it is being so werid.. yes it can run on the machine :facepalm:

You SQL is not the problem. The problem is a recursive event that is happening in your sql query. Either the stuidio has incerted an unusual character or you have one in the description field. Scroll through your sql query created by the stuido and look for a strange looking character in the text/data fields. It will have a ^ next to some characters. Sometimes this is a tab or control character that was accidently entered. Also you MUST Quote special characters in text fields, ie. /\{}[]:;"()or , and . are special characters and must be "ed.
(recursive event means that your sql statment is recalling it's self untill your memory is exausted)

Quote:

Originally Posted by russell0659 You SQL is not the problem. The problem is a recursive event that is happening in your sql query. Either the stuidio has incerted an unusual character or you have one in the description field. Scroll through your sql query created by the stuido and look for a strange looking character in the text/data fields. It will have a ^ next to some characters. Sometimes this is a tab or control character that was accidently entered. Also you MUST Quote special characters in text fields, ie. /\{}[]:;"()or , and . are special characters and must be "ed. (recursive event means that your sql statment is recalling it's self untill your memory is exausted)

Thank you so very much your help was actually the thing that helped me fix it thanks sooo much:handsdown:

This error comes up whenever u'r connect to wrong DB location as in if you downloaded SQLEXPR as main on the Service Instance instead of Default Instance, anyways it might also show up if you have SQL Express Service Pack 1 and SSMSE Service pack 2 or 3 you have to check on "Help > About" it will tell you if you have different packs.

easiest way to get the right one:

SQLEXPR (2005/2008/2012) - without the '()' -- First link
SSMSE (2005/2008/2012) - without the '()' -- First link

Just stop Shaiya Server Services . if you have 1G ram free you can run it . happend to me too.