Thanks for your feedback.

I have just been reading up on the meaning of Collation and Unicode.

From what I gather, your choice of datatype is driven by whether Unicode is required....

Hi Lynn

Does this number definitely represent the number of bytes needed?

Chris

Mmm doesn't make sense

Seems to be happening on a table where I import 3.5 million rows, which is not a lot. Have watched tempdb space, and it remains at 8mb...

Hi Lynn

17gb of disk space left, so don't surely space cannot be the issue then?

This is on a client old server - only 3.75 gb of ram. Could this be...

Thanks - will check it out!

Hi

I am trying to do the same thing.

Have you managed to resolve this??

Regards

Chris

Hi Guys

Same deal for us - data issues have been ruled out, there is nothing visibly wrong with the rows, and inconsistent when fall over, using exactly the same data...

Hi Everyone

Thanks very much for your help - exactly what I was looking for!

Regards

Chris

Hi Guys

Thanks for your feedback. Regarding SQL holding onto memory........

Does these mean that if SQL is holding onto 7GB of memory and running no processes, the full 7GB will be...

Thanks Syed - point taken RE only working with IE. This aside, is windows integrated security secure enough for us to be confident about our client's data..?

Should we also implement SSL with...

Thanks guys.

Regarding SSL - would this be good enough for security? If I implemented SSL, set up windows users on the server, and used windows security in IIS, would this...

thanks guys - exactly what I need!