SET TRANSACTION ISOLATION LEVEL within a function

Question

When I want to add the line

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

right after BEGIN clause of my function definition script in SQL SERVER 2008, it says:

Invalid use of a side-effecting operator 'SET TRANSACTION ISOLATION LEVEL' within a function

How can I achive this functionality within a function definition?

Answer 1

You can't.

You need to set this at the start of the batch that calls the function.