This makes perfect sense, micro$oft sense !  The specification for linked servers causes a select statement, so those permissions must exist.  This is one of the performance bottlenecks of linked...

Don't forget mentioning there are other options.

We use SQL Zip, as SQL Lite speed had issues with Named Instances.  I belive this has been corrected, but dealing with the tecnical...

Linked servers often will create cursors. Look through the documentation for Linked servers carefully and you will see statements such as:

"SQL Server uses IOpenRowset::OpenRowset on the base table...

Yes, I am using SQL 2000.

It is RAID 0 + 1.

Thanks for all the help so far. I may actually keep it the way it is, as I can't...