The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: A cursor uses the incorrect transaction isolation level after you change the transaction isolation level for the cursor in SQL Server 2005 http://support.microsoft.com/kb/940378/en-US...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/kba/archive/2007/08/25/1725.aspx