Alter All Data Types To Different Data Type
Changing datetime2 to datetime is a fundamental data type change. Each ALTER will update every row in the specified table.  This can take a while depending on the size of your tables, especially if your largest tables have many datetime2 columns. Also, if there is any other concurrent activity, the DDL will be blocked by other activity.