To know Compatibility Level of DB in SQL

SELECT compatibility_level
FROM sys.databases WHERE name = 'srs1';

ALTER DATABASE srs1 
SET COMPATIBILITY_LEVEL = 100