>John,
>
>>>>Hmmm, aren't you the guru ?? I can only think of one 'GURU' who said this, and he has lots of controversial statements in his pocket.<<
>
>>I'm not sure who you mean... *many* others advocate SPT/SP as "the way to go". I find that RVs work rather well.
>
>
>I also come to the conlcusion they work rather well, because they provide transparancy between local and remote data. However in some circumstances where you want to have flexible whereclause (like the &?cWhere clause in a local view) you cannot accomplish this with remote views without altering them (which I generally want to avoid). In these cases (mostly used for lookup services, I'm saldy left with SPT.
>
>>
http://fox.wikis.com/wc.dll?Wiki~MoreOnRemoteViews (which I wrote most of in exasperation at the dogma being spouted about RVs)
>
>I've read this and would like to thank you for your input in this article. Demistifying the myths arround differencees between RVs and SPT on a detailed level was about time.
>
Try
http://www.microsoft.com/technet/treeview/default.asp?url=/TechNet/prodtechnol/sql/deploy/depopt/SQLFOXPR.asp
George
Ubi caritas et amor, deus ibi est