Hi,
When setting the Data Access Mode to Table or View, the trace in PRofiler
looks something like this:
SET ROWCOUNT 1
SELECT * FROM Products
SET ROWCOUNT 1
SELECT * FROM Products
SET ROWCOUNT 1
SELECT * FROM Products
SELECT * FROM Products

Does anyone one know why it behaves like this? Why does it use SET ROWCOUNT,
and why does it execute the query several times?

Same thing if you use SQL Command and specify the query, isp_prepare and
sp_unprepare is used several times before actually executing the query.

Thanks,
--ola