As of a few months ago, i found a instance of SQL 7.0(!) installed on a box i had no idea existed until someone mentioned that it was failing a...

If you don't need any whitespace from the column, you could try wrapping the column in RTRIM & LTRIM statements, which should strip any extra unseen chars from the column.

PB_BI (4/13/2015)

---

coool_sweet (4/13/2015)

---

ok i did see my result in text editor in SSMS.

its not correct after phone its breaking into new line.

what should i change in my stored proc ,...

No, its not. Depending on how you're verifying the results, it may appear to be correct, but you may not be seeing what you need to see to fix...

Well you know where the problem is then. If its your code creating the file and you haven't accounted for malformed rows due to embedded control data, then fix...

If the source file is bad, make whoever sent it to you fix it.

look at your source file in notepad++ or its ilk and turn on visible control characters.

When you 'preview' from the datasource, does it look correct? If not, do you have embedded carriage returns or some other control chars in the source that might be...

Inside of it. Based on what you gave us, that's the best I can do right now.

Hmm.... good question. Is there a recommended size of tempdb as a % of the rest of the size of the farm databases?

Right not its not overly large,...

Do an sp_who2 and see where the connection is coming from.

Also make sure if you are doing this from SSMS that your open query is not connected to that...

I have a friend who is planning to implement on MS Access. I tried to convince him to use SQL Express instead, front-ending it with Access if he desired.

He...

SSRS or SSIS.

Make sure you use a 'throw' command in your error traps.

After a few more incidents where things get 'lost' because someone was being an idiot, even the idiots will usually figure it out.