Ive managed to fix the query. seems like it was a local issue on the database box, i opened the client network config utility and disabled the shared memory protocol....

its going to be a permanent server... , its actually going to be a production server to replace a "glitchy" production server.. lol

if it were a wins/dns resolution issue, would...

Hi

The query is being returned in query analyser using all defaults of the client. the max chars per col is set to 256 as default.

however, the issue is that it...