Question on READ_COMMITTED_SNAPSHOT

Peter
http://msdn2.microsoft.com/en-us/library/tcbchxcb(vs.80).aspx
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:uYpanLC1HHA.5380@.TK2MSFTNGP04.phx.gbl...
> Hi,
> We have migrated our HR system to SQL Server 2005 lately by a consultant.
> From the documentation, it mentions that he has set
> READ_COMMITTED_SNAPSHOT ON.
> We would like to know
> 1) What is the advantage for setting it ON ? From the web, it mentions
> that it will reduce the lock and will enhance performance.
> 2) Is there any way to find out whether the database has set
> READ_COMMITTED_SNAPSHOT ON ? I have tried sp_helpdb but it doesn't show
> up.
> Thanks
> Peter
>
>
Peter
select name,
is_read_committed_snapshot_on,
snapshot_isolation_state
from sys.databases
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:OwXI7vO1HHA.3916@.TK2MSFTNGP02.phx.gbl...
> Dear Uri,
> Thank you for your advice and I get a better understanding.
> However, is there any easy way to find out whether database has set
> READ_COMMITTED_SNAPSHOT on ?
> Peter
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O6x9$hD1HHA.4880@.TK2MSFTNGP03.phx.gbl...
>