hi dears
today i m face a very interesting problem is that in our erp system we gnerate .sql file from database publishing wizard and server genrate .sql file successfully . but when i am execute that file on our local system in sql server 2005 we will get error that "system.outofmemoryexception" .i google it and found the solution that this problem is related to sql server memory configuration
. actually default setting of sql server use 2 gb memory for executing the any query in database sql server 2005
then there is two option
1-first one is suggested by msdn is that expand your memory from 2gb to 3 gb
2- second which i try and got success which is dont execute query at once , divide ur query in bunch of some lines so you can execute them.and after one by one execute all bunch of sql queries
i know that my solution is temporary but its work for me..
Showing posts with label database publishing wizard. Show all posts
Showing posts with label database publishing wizard. Show all posts
Subscribe to:
Posts (Atom)
can you please explain me Backpropagation & Gradients in layman language as simple as possible
Absolutely! Let’s break down backpropagation and gradients in the simplest possible way , like we’re teaching a curious 10-year-old. 🎯...
-
The error message you encountered ("DeleteService FAILED 1072: The specified service has been marked for deletion") indicates tha...
-
Transformers have shown promising results in various natural language processing (NLP) tasks, but they can also be adapted for time series ...
-
The error message you're seeing indicates that the "global using directive" feature is currently unsupported in the version o...