Hi,
I have a view created thus:

if exists...
drop view MyView

SET QUOTED_IDENTIFIER OFF
GO

SET ANSI_NULLS ON
GO

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
GO

CREATE VIEW MyView
AS
.
.
.
-- end of My View

SET QUOTED_IDENTIFIER OFF
GO

SET ANSI_NULLS ON
GO

This view is created in a client database, but always executed from C# .NET
application

This view does a large number of joins, but is never used to update data.

My questions:

Does the setting of the TRANSACTION LEVEL cause all my tables
and joins to behave as if each one had a WITH (NOLOCK) clause added?

Do I actually have to have a transaction surrounding the SELECT statement
in order to use SET TRANSACTION LEVEL (it would seem so)?

What is the simplest way to cause some of my large Views to implement
completely
a NO LOCK strategy? It is obviously more convenient to have the view stored
in
the database to have the SQL necessary to accomplish my goal, but I am
unsure as
to what the implications are of executing the view from my C# windows app.
Any help would be greatly appreciated.

Chris Hough