Reginald J Ray Jr (3/7/2008)

---

This didn't work for me initially. It duplicated a column four times. I had to modify the code as below:

Original line:

...

Sorry everyone, I really got egg on my face with this one. :ermm: When I posted the question, I copied the wrong answer for answer #3. The missing #4 is...

BryanR (2/26/2008)

---

Useful, thanks!

One minor point: you've declared ObjectType as char(1), but it should be char(2) to match the xtype field in sysobjects. Functions have xtype='FN', so cause the batch...

I didn't realize that your (Jeff Moden's) first response referred to the original poster. My bad. :ermm:

I get a similar problem, but in the exact opposite way. When I run:

BULK INSERT Import

FROM 'C:\Import.txt'

WITH (FIELDTERMINATOR = '","', ROWTERMINATOR = '"', FIRSTROW=3522350, LASTROW=3522360, MAXERRORS = 100,

ERRORFILE =...

Just out of curiosity, I searched for my name, "Jesse McLain", in the Google search textbox in the upper-right hand corner. What came up was an entry by user "hxd001_810",...