<p>I want to insert say 50,000 records into sql server database 2000 at a time. How to accomplish this?</p>

Do you mean for a test of some kind?
```
```
declare @index integer
set @index = 0
while @index < 50000
begin
   insert into table
   values (x,y,z)
   set @index = @index + 1
end
```
```
But I expect this is not what you mean.
If you mean the best way to do a bulk insert, use
```
BULK INSERT
```
or something like
```
bcp
```