rocks (1/10/2013)
so In Snapshot , even i SP runs under transactions to read write, reporting SP's which are select script only will not get affected.
Correct. Writers do not block readers under read committed snapshot.
how about Indexes, if i rebuild indexes online will it block as well or not.
Different animal. Online index rebuilds do not block anything regardless of the isolation level. Nothing would change for you here if you enabled read committed snapshot.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato