Q: I am getting an error message when I try to run a script saying the transaction log is full due to active transactions.

A: To resolve this issue, open SQL Server Management Studio (SSMS) and locate your database. Right-click on the database name and select "Tasks > Shrink > Database".

If this does not resolve the issue, right-click on the database and select "Properties". In the properties box, select "Files" from the tree at the left. Next to the log file, click on the ellipse. A new box will open. Set the size of the log file to unlimited (or a size of your choosing, as long as it is large enough). Click "OK".

For more information, see https://www.sqldatatool.com/blog/transaction-log-full.