Well I solved the problem... It wasn't my SQL server and I didn't realize that it wasn't hosted on the computer I had been working on... All the files got...

GSquared (7/25/2008)

---

I just did this:

create database TestCSV

go

use TestCSV

go

create table dbo.testcsvdm (

ID int identity primary key,

Col1 varchar(100))

go

insert into TestCSV.dbo.testcsvdm (col1)

select number

from common.dbo.numbers -- Table with numbers from 0 to 10,000

go

EXEC master.dbo.XP_CMDSHELL...