>>Yes. By the way, there is not precompilation of SPs.
>>
>>http://weblogs.asp.net/fbouma/archive/2003/11/18/38178.aspx
>>
>>>
>
>Hi Mike -
>
>Thanks very much for posting this blog reference. Interesting stuff.
>
>For clarification : in the SQL World when they talk about Dynamic SQL isn't that a way of saying queries generated by the business layer - i.e. outside of SQL Server - i.e. SPT or Remote views? If I cam using remote views, am I sending to the backend what SQL Serverheads would consider to be Dynamic SQL ?

Hi Charles

We met at one of the conferences. It's been a long time!

I would say yes. Remote views must be considered "Dynamic" to the DBAs. The do required us to sp_executeSQL. Very interesting perspective!