What happens when you try the following inside a SQL Server Strored Procedure?

EXEC (‘CREATE TABLE #TEMPTABLE‘+‘123‘+‘(firstColumn varchar(10), secondColumn varchar(20), thridColumn int)‘)
INSERT INTO …

What does the transaction log contain?
Transaction log contains log records which are necessary for recovering or restoring a database.

What happens if these log records were never deleted from the transaction log?
Every transaction log has a fixed size….