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_PostingExtractValidateYou 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:
>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.
>> Hi,
>> Wanted to throw out a question to you SQL experts. I have 3149 views i
>[quoted text clipped - 17 lines]
>> CREATE VIEW dbo.VW_AR_PostingExtractValidate
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200603/1