Adding Read Uncommited to Views

Hi,
Wanted to throw out a question to you SQL experts. I have 3149 views i need
to add READ UNCOMMITED to.
They are currently scripted out waiting to be run on my replicated database.
My question is where do i put this statement?
I tried adding it after the AS like in a stored procedure, but SQL doesn't
like it. I haven't seen any documentation on this at all, even on this board..
..
HELP PLEASE...
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.VW_AR_PostingExtractValidate
You can't specify the transaction isolation level in the view definition.
You need to specify the WITH (NOLOCK) hint instead.
I suggest you do analysis before making wholesale changes to force
uncommitted reads. This is especially true for financial applications.
Data integrity is not guaranteed when you read uncommitted data.
Hope this helps.
Dan Guzman
SQL Server MVP
"sqlclubber" <u19392@.uwe> wrote in message news:5cdfe94eec857@.uwe...
> Hi,
> Wanted to throw out a question to you SQL experts. I have 3149 views i
> need
> to add READ UNCOMMITED to.
> They are currently scripted out waiting to be run on my replicated
> database.
> My question is where do i put this statement?
> I tried adding it after the AS like in a stored procedure, but SQL doesn't
> like it. I haven't seen any documentation on this at all, even on this
> board..
> .
> HELP PLEASE...
>
> SET QUOTED_IDENTIFIER ON
> GO
> SET ANSI_NULLS ON
> GO
> CREATE VIEW dbo.VW_AR_PostingExtractValidate
|||Thanks for your reply, Now i got to do a ctrl V 10 thousand times.
: (
Dan Guzman wrote:[vbcol=seagreen]
>You can't specify the transaction isolation level in the view definition.
>You need to specify the WITH (NOLOCK) hint instead.
>I suggest you do analysis before making wholesale changes to force
>uncommitted reads. This is especially true for financial applications.
>Data integrity is not guaranteed when you read uncommitted data.
>[quoted text clipped - 17 lines]
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200603/1