Toad for SQL Server 7.4 is now available on support.quest.com

Toad for SQL Server v7.4.0 can be viewed (along with release notes) here - Toad for SQL Server - Download Software