Thanks heaps Jack, that seems to work perfectly 🙂 Many thanks

Sure thing jack just use multiples of this:

INSERT INTO @Reccom (

KeyValue,

UserTitle,

Date,

Details

) VALUES...

I tested with the code below and varchar(max) acts as expected when concatenating with the + operator when the number of rows are known.. However a programmatic solution still seems...

Thanks guys, tried both those ideas however Jack, the limit is massive and checking len(@Summary) at the end of the code (not posted) shows my lengths to be tiny..

B, I...

Guys are you using clones in your virtual servers? if you clone a machine you must change the network card guid by re-installing the network card on the virtual...

Right that makes sense, cheers Phil

Really? I've never been able to get IP's to successfully work, if using IP addr's do they...

I had the same issue a while ago - you have to make sure that you use windows authentication with the exact same account, that it has appropriate permissions in...