yes I Did go through the article, but trying to see if we have any other solution available.

hi I am getting the same error, but in my case we have SQL 2005 64 bit on both side....

any help...

One correction here,

even when i run reports from reporting url from machine where reporting services are installed i am getting "NT AUTHORITY\ANONYMOUS LOGON" error.

i can see all reports and data...

Hi,

Thanks for quick reply.

but currently our 2005 setup is the same, and it works fine.

in fact it was...

we also perform same and may be you want to update your view , below is the script.

DECLARE @view AS VARCHAR(255) ;

DECLARE ListOfViews CURSOR FOR

SELECT TABLE_SCHEMA + '.' +TABLE_NAME...

it worked after re-deploying reports.

i was going through the document you asked me to go through and i found below.

"In systems that have a high percentage of data changing, enabling the use of the...

so In Snapshot , even i SP runs under transactions to read write, reporting SP's which are select script only will not get affected. how about Indexes, if i rebuild...

So i need to change all my SP's and Views to avoid nolock hint.

so in this snapshot isolation level no locking happens at all for reporting scripts ( for...

So How does it work, its the isolation level i need to change.

yes users understand these type of dirty read might happen.

HI,

Thanks for quick reply, I have gone through the post. so what is the best way to avoid this locks. we are using nolock hint as...

I See PAGEIOLATCH_SH ,writelog wait type are common here in my environment now a days.

it cache latch. not catch its typo.

Did you get any solution for this , as i got the same error.