<div>
Here's how to change it at DB level:<br />
<a href="http://msdn.microsoft.com/en-us/library/bb522682.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/bb522682.aspx</a><br />
ALTER DATABASE AdventureWorks SET READ_COMMITTED_SNAPSHOT {ON | OFF }<br />
<br />
As far as swithcing back and use NOLOCK hint I suggest you read the article below before deciding to go that way to see and understand what NOLOCK means and does:<br />
<br />
<a href="http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx" rel="ugc">http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx</a>
</div>


Here's how to change it at DB level:
http://msdn.microsoft.com/en-us/library/bb522682.aspx [http://msdn.microsoft.com/en-us/library/bb522682.aspx]
ALTER DATABASE AdventureWorks SET READ_COMMITTED_SNAPSHOT {ON | OFF }

As far as swithcing back and use NOLOCK hint I suggest you read the article below before deciding to go that way to see and understand what NOLOCK means and does:

http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx [http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx]

<div>
my question is i have a database with read commited snapshot isolation level &nbsp;however the databse is hitting with a qurey with No Lock Hint.which will override(reading data from tempdb due to read commited snap shot or dirty reads due to No Lock Hint)?
</div>


my question is i have a database with read commited snapshot isolation level  however the databse is hitting with a qurey with No Lock Hint.which will override(reading data from tempdb due to read commited snap shot or dirty reads due to No Lock Hint)?

<div>
Excellent Really helpfull to me
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am using isolation level at database level as read committed snapshot however i am using no lock hint at statement level.which one will overide first? one more thing is i would like to change read commited snapshot to default isolation at database level.how to do it?
</div>
</div>


Hi

I am using isolation level at database level as read committed snapshot however i am using no lock hint at statement level.which one will overide first? one more thing is i would like to change read commited snapshot to default isolation at database level.how to do it?

sqlserver 2008 Isolation question

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.