tsql default values, check current isolation level, check db object last update time

1) ALTER TABLE teseTable ADD column1 char(1)   default 'S'  with values

with values will set values for for new column for existing rows. 

2) check current isolation level

SELECT CASEtransaction_isolation_level

WHEN 0 THEN'Unspecified'

WHEN 1 THEN'ReadUncommitted'

WHEN 2 THEN'ReadCommitted'

WHEN 3 THEN'Repeatable'

WHEN 4 THEN'Serializable'

WHEN 5 THEN'Snapshot' END AS TRANSACTION_ISOLATION_LEVEL

FROMsys.dm_exec_sessions

where session_id =@@SPID

3)check db object last update time

SELECTDB_NAME(ius.[database_id]) AS [Database],

OBJECT_NAME(ius.[object_id])AS [TableName],

MAX(ius.[last_user_lookup])AS [last_user_lookup],

MAX(ius.[last_user_scan])AS [last_user_scan],

MAX(ius.[last_user_seek])AS [last_user_seek]

FROMsys.dm_db_index_usage_stats AS ius

WHEREius.[database_id] = DB_ID()

AND ius.[object_id]= OBJECT_ID('PFAcctHierarchy')

GROUP BYius.[database_id], ius.[object_id];