Hi

Ignore the last post - I altered one of the other views that the script was looking at which wasn't working and now it verifies and runs.

Really appreciate your...

Thanks Slick/Lynn for the advice - that has worked a treat.

I added aliases and the SQL now verifies. I've inherited this so I finding lots of worms and woodwork.

The problem...

Hi

Finally got access to site

The two linked servers are "blkviztopia" and "blkviztopia\cch"

There doesn't appear to be any aliases in it.

At the end of this message I've also posted the...

Thanks Slick - I'll check as far as I know there weren't any, but not 100% sure

Here's the code for the view:

SELECT ISNULL(dbo.Contact.FName + ' ', '') + ISNULL(dbo.Contact.LName, ' ') AS companyFullName, dbo.ClientSupplier.ClientID, dbo.Contact.ContactID,

...