Does snapshot in two database has any know issue in following situation.

• rajemessage 14195

  Hall of Fame

  Points: 3315

  More actions

  June 23, 2014 at 8:14 am

  #150164

  Hi,

  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.

  yours sincerely.

• rajemessage 14195

  Hall of Fame

  Points: 3315

  More actions

  July 1, 2014 at 6:56 am

  #1726159

  Should i post it in any other category?

  yours sincerley.