Sometimes it is required to manage large SQL scripts, especially if you want to migrate data by hand. Let's see how it is look like with Microsoft Sql Management Studio:
I had the SQL script and opened using the file open function. I wanted to reorganize the file using the copy/past feature, when this dialog appeared:
"You are attempting to copy more than 194049 lines to the Clipboard. This may decrease performance." 194049 lines didn't seem to a large amount of data (in the end of 2006).
Anyway I was able to copy/paste, but it was terribly slow. After the modifying the file I also wanted to run it:
The memory was not enough, my PC had 1 GB. Check the details of the exception, it was a usual .Net stack trace:
Finally, I manged to execute the script in multiple smaller parts, but after I wanted to save it:
"The operation could not be completed. Not enough memory." - at least the second part of the error message was translated to Hungarian.
It seems a game of hazard to find the proper button at the bottom of the screen.
I become curios about this well defined error message, and tired the "Help" option, but it provided the "expected result":
Of course the "Information Not Found".
But it was not.
Translation:
Why don't you reinstall your whole operation system, after a build error?
Eastern Europe overcame Russia:
I have to update my geographical knowledge.
It is quite hard to choose "Yes" or "No" because only a checkbox is there. But there is an other interesting solution: Apostrophes are escaped in the text. It is not so garish for ''Yes'' and ''No'', but won''t looks strange.
I was a bit strange, why the value is invalid, so I checked the details:
So, I am not able to modify the file, while building or debugging, that is ok, but why the value is invalid because of this?
Thanks Gusty for this screen.
If you try to specify the start date, a nice feature can be seen:
"You are attempting to copy more than 194049 lines to the Clipboard. This may decrease performance." 194049 lines didn't seem to a large amount of data (in the end of 2006).
The memory was not enough, my PC had 1 GB. Check the details of the exception, it was a usual .Net stack trace:
Finally, I manged to execute the script in multiple smaller parts, but after I wanted to save it:
"The operation could not be completed. Not enough memory." - at least the second part of the error message was translated to Hungarian.
