Long TSQL Script 
Author Message
 Long TSQL Script

I am running 1000 line long script.  It crashes.  This is a conversion
script to take a table that is all character based and convert it but there
are someother fancy hoops I have to jump through hence the long script.
Really it is just a long insert into script. What I was wondering if there
is someway to push up the size of the script that can run or a method of
running them in batches.  By the way I am running NT4.0 SQL6.5

Doug Swarts



Fri, 17 Dec 1999 03:00:00 GMT
 Long TSQL Script

Doug,

 You can always split it up with GO's in-between statements.  

 Neil Pike MVP/MCSE
 Protech Computing Ltd (MS Solution Provider)
 Using Virtual Access 4.00 build 213a (32-bit) on NT 4.0 SP3



Sun, 19 Dec 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. How can I script db from tsql script?

2. Long Text in TSQL

3. how to convert a long string to ntext variable(TSQL) by ADO used in C++

4. in C++,how to convert a long string to ntext variable(TSQL) by ADO

5. Running TSQL scripts in MSDE

6. TSQL Scripting of Create Table

7. Scripting DB Objects using TSQL

8. scripting object through TSQL

9. Batch TSQL Script with SQLDMO

10. tsql scripts

11. running SQL script (TSQL) file in VB

12. Job with TSQL script does not work


 
Powered by phpBB® Forum Software