Many thanks for the reply.

Why is this not the recommended approach given that business logic is stored in functions on the remote server, and we don't want to maintain udf's in...

Scalar - will be returning same single value given the same input.

I've have done and it doesn't work. I get the error :

The object name 'REMOTE_SERVER_NAME.database.dbo.' contains more than the maximum number of prefixes. The maximum is 2.

Sorry, my original question...

Kathi,

Thanks for your response. Hopefully I will get round to trying your suggestions next week.

quote:

---

There are 3 main reasons why I choose SS:

1. VB is really really a great programming language, but Developer...