Hi,
I have a procedure which has about 300 arguments which calls another procedure to perform some tasks which runs successfully in "SQL Sever 2008 R2" whenever i migrate to SQL Sever 2012 run that procedure it throws an error saying:-
Internal error: Server stack limit has been reached. Please look for potentially deep nesting in your query, and try to simplify it.
Can anyone have help me out with why this error is occurring. I have used 4GB RAM and 64 bit OS.