http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_9ooj.asp
- from BOL v8.
It may not be relevant, but interestingly in BOL v9 the following is inserted just before the final paragraph:
OPENROWSET and OPENQUERY support pass-through queries in which the query string contains a stored procedure call only when the query has one of the following characteristics:
- Executes a single, static SELECT statement.
- Does not use any dynamic EXECUTE statements.
- Does not perform any data modification operations.
There is no indication that this is a new 'feature' introduced in SQL9. It's more likely a long-standing restriction, perhaps arising from the need to support distributed transactions.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant