Split a very large SQL table to multiple smaller tables
Addressing the question behind the question:


  Maybe you can answer this. Is it possible to search a column within a table for a numerical value range of 1-2000 and then copy each full row into a different table?


If you already have a column by which you can "partition" the table, then you can do something like this:

SELECT * 
 INTO dbo.newtable_0001_to_2000 
 FROM dbo.existingtable 
 WHERE column &gt;= 1 AND column &lt;= 2000;

SELECT * 
 INTO dbo.newtable_2001_to_4000 
 FROM dbo.existingtable 
 WHERE column &gt;= 2001 AND column &lt;= 4000;

...


Just note that this will give you a predictable number of rows, but won't control the size of the rows, so depending on the data in each "partition" these tables will not likely be of equal sizes.