Does DBCC USEROPTIONS report the snapshot isolation as 'snapshot'?

Hi,

I am using SQL Server 2005 Development Edition. I have a database named 'SnapshotTest'.

When I issue the following

ALTERDATABASE SnapshottestSET ALLOW_SNAPSHOT_ISOLATIONON

USE Snapshottest

DBCCUSEROPTIONS;

I get the output asisolation level read committed

If someone can explain the reason, it will be great.

I had seen two transactions blocking each other that is why I executed DBCC Useroptions.

Thanks,

payyans

[1183 byte] By [payyans] at [2007-12-19]

SQL Server Hot Topic