How To Show the Current Size of the Transaction Log in MS SQL Server

In MS SQL Server, change the DATABASE_NAME_HERE to the appropriate database name and then run the following SQL query:

SELECT (size * 8.0)/1024.0 AS size_in_mb, CASE WHEN max_size = -1 THEN 9999999 ELSE (max_size * 8.0)/1024.0  END AS max_size_in_mb FROM DATABASE_NAME_HERE.sys.database_files  WHERE data_space_id = 0;