    SELECT is_read_committed_snapshot_on FROM sys.databases 
    WHERE name= &#39;YourDatabase&#39;

Return value:  

- **1**: `READ_COMMITTED_SNAPSHOT` option is **ON**. Read operations under the `READ COMMITTED` isolation level are based on snapshot scans and do not acquire locks.
- **0** (default): `READ_COMMITTED_SNAPSHOT` option is **OFF**. Read operations under the `READ COMMITTED` isolation level use [Shared (S) locks][1].


  [1]: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms175519(v=sql.105)

1. As per [DBCC USEROPTIONS (Transact-SQL)][1]:
&gt; DBCC USEROPTIONS reports an isolation level of &#39;read committed snapshot&#39; when the database option READ_COMMITTED_SNAPSHOT is set to ON and the transaction isolation level is set to &#39;read committed&#39;. The actual isolation level is read committed.

2. Also in SQL Server Management Studio, in database properties under Options-&gt;Miscellaneous there is &quot;Is Read Committed Snapshot On&quot; option status


  [1]: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-useroptions-transact-sql

Neither on SQL2005 nor 2012 does `DBCC USEROPTIONS` show `is_read_committed_snapshot_on`:

    Set Option	Value
    textsize	2147483647
    language	us_english
    dateformat	mdy
    datefirst	7
    lock_timeout	-1
    quoted_identifier	SET
    arithabort	SET
    ansi_null_dflt_on	SET
    ansi_warnings	SET
    ansi_padding	SET
    ansi_nulls	SET
    concat_null_yields_null	SET
    isolation level	read committed

Now, before you say it: I **did** Google and my `hbm.xml` file **is** an Embedded Resource. 

Here is the code I am calling:

    ISession session = GetCurrentSession();
    var returnObject =  session.Get&lt;T&gt;(Id);

Here is my mapping file for the class:

&lt;!-- language: lang-xml --&gt;

    &lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot; ?&gt;
    &lt;hibernate-mapping xmlns=&quot;urn:nhibernate-mapping-2.2&quot;&gt;
      &lt;class name=&quot;HQData.Objects.SubCategory, HQData&quot; table=&quot;SubCategory&quot; lazy=&quot;true&quot;&gt;
        &lt;id name=&quot;ID&quot; column=&quot;ID&quot; unsaved-value=&quot;0&quot;&gt;
          &lt;generator class=&quot;identity&quot; /&gt;
        &lt;/id&gt;
    
        &lt;property name=&quot;Name&quot; column=&quot;Name&quot; /&gt;
        &lt;property name=&quot;NumberOfBuckets&quot; column=&quot;NumberOfBuckets&quot;  /&gt;
        &lt;property name=&quot;SearchCriteriaOne&quot; column=&quot;SearchCriteriaOne&quot; /&gt;
        
        &lt;bag name=&quot;_Businesses&quot; cascade=&quot;all&quot;&gt;
          &lt;key column=&quot;SubCategoryId&quot;/&gt;
          &lt;one-to-many 
             class=&quot;HQData.Objects.Business, HQData&quot;/&gt;
        &lt;/bag&gt;
    
        &lt;bag name=&quot;_Buckets&quot; cascade=&quot;all&quot;&gt;
          &lt;key column=&quot;SubCategoryId&quot;/&gt;
          &lt;one-to-many
             class=&quot;HQData.Objects.Bucket, HQData&quot;/&gt;
        &lt;/bag&gt;
    
      &lt;/class&gt;
    &lt;/hibernate-mapping&gt;

Has anyone run to this issue before?

Here is the full error message:

&gt; &lt;pre&gt;MappingException: No persister for:  HQData.Objects.SubCategory]NHibernate.Impl.SessionFactoryImpl.GetEntityPersister(String entityName, Boolean throwIfNotFound)
 in c:\CSharp\NH2.0.0\nhibernate\src\NHibernate\Impl\SessionFactoryImpl.cs:766 NHibernate.Impl.SessionFactoryImpl.GetEntityPersister(String entityName)
 in c:\CSharp\NH2.0.0\nhibernate\src\NHibernate\Impl\SessionFactoryImpl.cs:752 NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType)
 in c:\CSharp\NH2.0.0\nhibernate\src\NHibernate\Event\Default\DefaultLoadEventListener.cs:37 NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType)
 in c:\CSharp\NH2.0.0\nhibernate\src\NHibernate\Impl\SessionImpl.cs:2054 NHibernate.Impl.SessionImpl.Get(String entityName, Object id)
 in c:\CSharp\NH2.0.0\nhibernate\src\NHibernate\Impl\SessionImpl.cs:1029 NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id)
 in c:\CSharp\NH2.0.0\nhibernate\src\NHibernate\Impl\SessionImpl.cs:1020 NHibernate.Impl.SessionImpl.Get(Object id)
 in c:\CSharp\NH2.0.0\nhibernate\src\NHibernate\Impl\SessionImpl.cs:985 HQData.DataAccessUtils.NHibernateObjectHelper.LoadDataObject(Int32 Id)
 in C:\Development\HQChannelRepo\HQ Channel Application\HQChannel\HQData\DataAccessUtils\NHibernateObjectHelper.cs:42 HQWebsite.LocalSearch.get_subCategory()
 in C:\Development\HQChannelRepo\HQ Channel Application\HQChannel\HQWebsite\LocalSearch.aspx.cs:17 HQWebsite.LocalSearch.Page_Load(Object sender, EventArgs e)
 in C:\Development\HQChannelRepo\HQ Channel Application\HQChannel\HQWebsite\LocalSearch.aspx.cs:27 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436&lt;/pre&gt;

**Update**, here&#39;s what the solution for *my* scenario was: I had changed some code and I wasn&#39;t adding the Assembly to the config file during runtime. 

NHibernate.MappingException: No persister for: XYZ

Every time I turn on my company-owned development machine, I have to kill 10+ processes using the Task Manager or any other process management app just to get decent performance out of my IDE.  Yes, these are processes from programs that my company installs on my machine for security and compliance. What I&#39;d like to do is have a .bat file or script of some kind with which I can kill the processes in question.  

Does anybody know how to do this?

Any way to write a Windows .bat file to kill processes?

In Microsoft SQL Server, is there a way to detect whether a database has had its isolation level set via the T-SQL command `ALTER DATABASE &lt;database&gt; SET READ_COMMITTED_SNAPSHOT ON;`?

I cannot find a simple way to detect this in either T-SQL or via the Management Studio&#39;s GUI.


How to detect READ_COMMITTED_SNAPSHOT is enabled?

<p>In Microsoft SQL Server, is there a way to detect whether a database has had its isolation level set via the T-SQL command <code>ALTER DATABASE &#x3C;database> SET READ_COMMITTED_SNAPSHOT ON;</code>?</p>
<p>I cannot find a simple way to detect this in either T-SQL or via the Management Studio's GUI.</p>


I&#39;ve noticed that Visual Studio 2008 is placing square brackets around column names in sql. Do the brackets offer any advantage? When I hand code T-SQL I&#39;ve never bothered with them.

Example:

Visual Studio:

    SELECT [column1], [column2] etc...

My own way:

    SELECT column1, column2 etc...


What is the use of the square brackets [] in sql statements?

What is the best way to sort the results of a sql query into a random order within a stored procedure?

SQL Server Random Sort

I have a table with an XML column. This column is storing some values I keep for configuring my application. I created it to have a more flexible schema.
I can&#39;t find a way to update this column directly from the table view in SQL Management Studio. Other (INT or Varchar for example) columns are editable. I know I can write an UPDATE statement or create some code to update it. But I&#39;m looking for something more flexible that will let power users edit the XML directly.

Any ideas?

&gt; Reiterating again: Please don&#39;t answer
&gt; I can write an application. I know
&gt; that, And that is exactly what I&#39;m
&gt; trying to avoid.

How to easily edit SQL XML column in SQL Management Studio

The following SQL:

    SELECT notes + &#39;SomeText&#39;
    FROM NotesTable a 

Give the error:

&gt; The data types nvarchar and text are incompatible in the add operator.


How do I concatenate text in a query in sql server?

What’s the best way to capitalise the first letter of each word in a string in SQL Server.

What’s the best way to capitalise the first letter of each word in a string in SQL Server

How long should it take to run 

    ALTER DATABASE [MySite] SET READ_COMMITTED_SNAPSHOT ON

I just ran it and it&#39;s taken 10 minutes.

How can I check if it is applied?

How long should SET READ_COMMITTED_SNAPSHOT ON take?

How do you find current database&#39;s transaction level on SQL Server?



How to find current transaction level?

In plain English, what are the disadvantages and advantages of using

    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

in a query for .NET applications and reporting services applications?

Why use a READ UNCOMMITTED isolation level?

Could some one please help me understand when to use SNAPSHOT isolation level over READ COMMITTED SNAPSHOT in SQL Server?

I understand that in most cases READ COMMITTED SNAPSHOT works, but not sure when go for SNAPSHOT isolation.

Thanks

Read committed Snapshot VS Snapshot Isolation Level

I think the above isolation levels are so alike. Could someone please describe with some nice examples what the main difference is ? 


Difference between &quot;read commited&quot; and &quot;repeatable read&quot;

I&#39;m using a Microsoft SQL Server 2005 database with isolation level `READ_COMMITTED` and `READ_COMMITTED_SNAPSHOT=ON`.

Now I want to use:

    SELECT * FROM &lt;tablename&gt; FOR UPDATE

...so that other database connections block when trying to access the same row &quot;FOR UPDATE&quot;.

I tried: 

    SELECT * FROM &lt;tablename&gt; WITH (updlock) WHERE id=1

...but this blocks all other connections even for selecting an id other than &quot;1&quot;.

Which is the correct hint to do a `SELECT FOR UPDATE` as known for Oracle, DB2, MySql?

**EDIT 2009-10-03:**

These are the statements to create the table and the index:

    CREATE TABLE example ( Id BIGINT NOT NULL, TransactionId BIGINT, 
        Terminal BIGINT, Status SMALLINT );
    ALTER TABLE example ADD CONSTRAINT index108 PRIMARY KEY ( Id )
    CREATE INDEX I108_FkTerminal ON example ( Terminal )
    CREATE INDEX I108_Key ON example ( TransactionId )

A lot of parallel processes do this `SELECT`:

    SELECT * FROM example o WITH (updlock) WHERE o.TransactionId = ?

**EDIT 2009-10-05:**

For a better overview I&#39;ve written down all tried solutions in the following table:
&lt;pre&gt;
mechanism              | SELECT on different row blocks | SELECT on same row blocks
-----------------------+--------------------------------+--------------------------
ROWLOCK                | no                             | no
updlock, rowlock       | yes                            | yes
xlock,rowlock          | yes                            | yes
repeatableread         | no                             | no
DBCC TRACEON (1211,-1) | yes                            | yes
rowlock,xlock,holdlock | yes                            | yes
updlock,holdlock       | yes                            | yes
UPDLOCK,READPAST       | no                             | no

I&#39;m looking for        | no                             | yes
&lt;/pre&gt;



Content Type	Original Author	Original Content on Stackoverflow
Question	Chris Driver	View Question on Stackoverflow
Solution 1 - Sql Server	Galwegian	View Answer on Stackoverflow
Solution 2 - Sql Server	MikeL	View Answer on Stackoverflow
Solution 3 - Sql Server	user3164106	View Answer on Stackoverflow

How to detect READ_COMMITTED_SNAPSHOT is enabled?

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Any way to write a Windows .bat file to kill processes?

NHibernate.MappingException: No persister for: XYZ

Attributions