To limit the size of the SQL Server error log, the sp_cycle_errorlog system stored procedure can be issued to start a new error log.
To recycle SQL Server Agent log you can execute sp_cycle_agent_errorlog system stored procedure.
Click on below link to download Denali
http://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx
You can use below query to check the database isolation level.
DBCC UserOptions
| SQL Server Version | Code Name |
| SQL Server 6.0 | SQL95 |
| SQL Server 6.5 | Hydra |
| SQL Server 7.0 | Sphinx |
| SQL Server 7.0 OLAP | Plato |
| SQL Server 2000 32-bit | Shiloh |
| SQL Server 2000 64-bit | Liberty |
| SQL Server 2005 | Yukon |
| SQL Server 2008 | Katmai |
| SQL Server 2008 R2 | Kilimanjaro |
| SQL Server 2011 | Denali |
aiDeeva.com 