64K Limit
I have a sql script that is comprised of several create tables and create Stored Procedures. The file is approx 457kb. I have always been able to run this script in query analyzer for SQL7\2000. Of course that is until now.
When the script is opened an error message to the effect of file contains long line over 64k limit.
I tried to trim down the code (removed all my if exists kind of stuff). I don't get an error now. When I run the script, it is only runs the first part of the script,truncates the script, adds a few weird characters to the end of the scripts. It is probably taking the first 64k.
Is there a setting in sql that can fix this problem?
I'm trying to avoid splitting up the script into 64k chunks .
|
