Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Script Table Data to Insert Statements Expand / Collapse
Author
Message
Posted Friday, April 13, 2012 5:11 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 2:07 PM
Points: 486, Visits: 1,360
Tried this script on a 2005 SP3 system, to try and construct insert statements for a rather large table of data (hundreds of millions of rows). Needless to say - it didn't work, and through and out of memory exception error in the messages section of the results at about 33 million. :-/
Post #1283541
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse