How to check database ISOLATION Level?

You can use below query to check the database isolation level.

DBCC UserOptions

SQL Server Version and Code Name

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

Find the create and modified date of Database Objects

Query

SELECT name, create_date, modify_date
FROM sys.objects