# script: scripts/00_discovery.sql | database: lab-cst | started (UTC): 2026-10-16 01:49:37
/* 00 - Discovery (run on BOTH databases, read-only)
   Goal: confirm the feature surface exists (catalog + DMV columns) and capture the starting state. */
SET NOCOUNT ON;
PRINT '=== 00 Discovery on ' + DB_NAME();
=== 00 Discovery on lab-cst
SELECT @@VERSION AS engine_version;
engine_version
--------------
Microsoft SQL Azure (RTM) - 12.0.2000.8 
	Sep 17 2026 07:51:49 
	Copyright (C) 2026 Microsoft Corporation


PRINT '--- Database-scoped TIME_ZONE setting (expected LOCAL = UTC by default)';
SELECT name, value, value_for_secondary, is_value_default
FROM sys.database_scoped_configurations WHERE name = 'TIME_ZONE';
--- Database-scoped TIME_ZONE setting (expected LOCAL = UTC by default)
name|value|value_for_secondary|is_value_default
----|-----|-------------------|----------------
TIME_ZONE|LOCAL|NULL|1

PRINT '--- Session-level time zone column in sys.dm_exec_sessions';
SELECT session_id, time_zone FROM sys.dm_exec_sessions WHERE session_id = @@SPID;
--- Session-level time zone column in sys.dm_exec_sessions
session_id|time_zone
----------|---------
67|LOCAL

PRINT '--- Effective time zone';
SELECT CURRENT_TIMEZONE_ID() AS tz_id, CURRENT_TIMEZONE() AS tz_display;
--- Effective time zone
tz_id|tz_display
-----|----------
UTC|(UTC) Coordinated Universal Time

PRINT '--- Time zones available (count) and the ones used in this lab';
SELECT COUNT(*) AS zones_available FROM sys.time_zone_info;
SELECT name, current_utc_offset, is_currently_dst
FROM sys.time_zone_info
WHERE name IN ('UTC', 'Central Standard Time', 'Central America Standard Time', 'Canada Central Standard Time',
               'Eastern Standard Time', 'Pacific Standard Time', 'India Standard Time',
               'Tokyo Standard Time', 'Nepal Standard Time', 'New Zealand Standard Time')
ORDER BY current_utc_offset;
--- Time zones available (count) and the ones used in this lab
zones_available
---------------
141

name|current_utc_offset|is_currently_dst
----|------------------|----------------
UTC|+00:00|0
India Standard Time|+05:30|0
Nepal Standard Time|+05:45|0
Tokyo Standard Time|+09:00|0
New Zealand Standard Time|+13:00|1
Eastern Standard Time|-04:00|1
Central Standard Time|-05:00|1
Canada Central Standard Time|-06:00|0
Central America Standard Time|-06:00|0
Pacific Standard Time|-07:00|1

# sqlcmd exit code: 0