I'm not sure about whether setting the transaction isolation level will
apply to the view as well, but if not, you could use the NOLOCK
optimiser hint in the view to prevent locks.

-----Original Message-----
From: John A DAVIS
[mailto:mssqldba-ezmlmshield-x3227073.[Email address protected]
Sent: 29 September 2006 00:08
To: LazyDBA Discussion
Subject: today is my Friday but have great unknown unsearchable
question. . . .


We are running select queries on tons of Views for our Drinking Water
website with PHP pages. Now, I can put this: SET TRANSACTION ISOLATION
LEVEL READ UNCOMMITTED at the front of the SELECT * FROM vwYourViewHere
in PHP and everything runs and the idea is to not lock any tables.

. . . . . .but. . . . . does this work with Views? Don't the views lock
the table because they are farther down the food chain?

thank you


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page