I have two database D1 and D2, i am using snapshot isolation (ALTER DATABASE MyDatabase
SET ALLOW_SNAPSHOT_ISOLATION ON) in both database.
Following is the situation.
1) situation is one SP sp1 ( it can be in any database d1 or d2) updates d2 from d1.
2) d2 is used for reading by web, execept above SP sp1
3) d1 gets updation from web in readcommite isolation.
4) both database will be on same instence.
i am checking from my side in all possible cases.
q1) please tel me, if any issue can come in this situation.