MS SQL Server - Statement settings

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Statement settings

Gerko

2006-01-26, 4:53 pm

When use SQL Server Management Studio (SQL 2005), how can you see if
READ_COMMITTED_SNAPS
HOT is ON or OFF?

Greg Low [MVP]

2006-01-26, 4:53 pm

Hi Gerko,

Try executing:

select
name,snapshot_isolat
ion_state,snapshot_i
solation_state_desc,
is_read_committed_sn
apshot_on
from sys.databases

HTH,

Greg
"Gerko" <Gerko@discussions.microsoft.com> wrote in message
news:2FD03D74-4154-485A-9EC1- AF21BB7ACBDA@microso
ft.com...
> When use SQL Server Management Studio (SQL 2005), how can you see if
> READ_COMMITTED_SNAPS
HOT is ON or OFF?

Sponsored Links