ALTER DATABASE @dbname SET ALLOW_SNAPSHOT_ISOLATION ON;

ALTER DATABASE @dbname SET READ_COMMITTED_SNAPSHOT ON;

After i set these 2 option, do i still need to use SET Transaction Isolation Level Snapshot on each of...

Will this be an issue when using Read_Committed_Snapshot ?

http://sqlblog.com/blogs/linchi_shea/archive/2007/10/05/performance-impact-the-potential-cost-of-read-committed-snapshot.aspx

And also 1 question,

I have 10 records in my table , and i begin transaction and start update 1...

thanks , i will give it a try...

By the way,

How to optimize tempdb if i want to use Snapshot Isolation

Ok let me give some more detail and hope you guys can give me a good suggestion....

Live DB A => accept data from Web , handphone and pda

Live DB B...

So what method you suggested ?? and is the best for my situation