Thanks John, I didn't know of SELECT INTO and misread it as INSERT INTO.

Doing as you suggested has shown me that in this instance '1' got evaluated as an INT.

I don't understand what you mean because if I SELECT INTO an existing table, doesn't that mean the table I am selecting into already has its datatypes defined? So if...

Mr Brian Gale - you asked if this was a cross-database query, and that's exactly what it turned out to be, thank you. I needed to grant datareader permissions in...

Hi Sue, I have tried the script you linked to, thanks. However it does not return anything that was created for our database, instead it returns items that appear to...

Thanks Brian.

Since checking the AG was set against the datasource and dataset correctly, my Administrator has been able to enable remote errors for me this morning and I now have...

Thanks Sue, I read the post. The stuff about XML was a bit over my head, however there was a nifty answer in the comments that resolved this for me,...

I tried putting the results in to a variable and selecting the datalenght() of that, I can see that the lenght is longer so I assume it does contain all...

Thanks, I tried, however outputting to file also seems to have the truncating problem

It sounds like you might need to use the FOR XML clause. Would something like this help you? You can copy and paste the entire code in to a new...