There is location on the server where file is created using that clr procedure. I have source code but cant run the project as it's locked by some encrpted key...

Hi Gail,

thanks for your valuable comments.

Hi Gail

thanks alot for the pointer.

Gentlemen, thanks alot for your comments.

Do you mind sharing the circumstances in which both the index will be required? I am not able to anticipate the same.

thanks for the info.

the traffic is quite high on live and I dont have access to live. I can only test the same on dev. so now for me its...

thanks alot for the same.

cheers

Hi Paul,

If you have time, could you please share more on index views and the RangeS-S locks or just please forward me the url's if any with you.

cheers

I have just conducted the test on dead locks and came to know that out of 2 issues, one is sorted.

Also when i submitted the trace file to Data base...

Hi Gail

Could you please let me know how to check connection setting in profiler?

One more thing, I have checked in dead lock graph, I can see isolationlevel="serializable (4)" in process...

Yes, we are not changing any isolation level in code.

Could you please share your experience on range locks and on views, how the same works?

Yes, dbo.RequestStatus is a table.

Yes, we can repordue the same. We are not setting any isolation level in code through procs.

Thanks alot for the link and name of the book.

cheers

There are one view which is base on RequestStatus table. I have check the code and its not being accessed in the procs which are there in dead lock graph....

In the procs, we are not using any isolation level. We are using read committed which is there by default. That's why I am also confused.

cheers

http://www.mssqltips.com/tip.asp?tip=1234, this would also help.

the issue is sorted. On one data base trusworty was set to on and on another data base it was set automatically to off when data base was restored from...