If you execute any script in SQL SEVER (Any Database) and you got any error "insufficient memory to complete operation" like this,
then please use GO statement after 50 rows or 100 rows just an example. If you execute any script which has around 65,000 update statement with out any GO statement. Now in this time SQL SERVER is assuming this is single BATCH which has 65,000 rows and its trying to execute in single shot and it will give a error "insufficient memory to complete operation".
For resolving this issue please add GO statement after some of the rows(Like 50 or 100).And its assuming we have so many BATCHES and executed successfully without any error.
Thanks,
Kapil.
then please use GO statement after 50 rows or 100 rows just an example. If you execute any script which has around 65,000 update statement with out any GO statement. Now in this time SQL SERVER is assuming this is single BATCH which has 65,000 rows and its trying to execute in single shot and it will give a error "insufficient memory to complete operation".
For resolving this issue please add GO statement after some of the rows(Like 50 or 100).And its assuming we have so many BATCHES and executed successfully without any error.
Thanks,
Kapil.
No comments:
Post a Comment
Share your thoughts....