-- 照合順序確認
SELECT name, collation_name FROM sys.databases;
-- 互換レベル確認
SELECT name,compatibility_level FROM sys.databases ;
-- 分離レベル(isolation level列確認)
dbcc useroptions;
More than 5 years have passed since last update.
-- 照合順序確認
SELECT name, collation_name FROM sys.databases;
-- 互換レベル確認
SELECT name,compatibility_level FROM sys.databases ;
-- 分離レベル(isolation level列確認)
dbcc useroptions;
Register as a new user and use Qiita more conveniently