Just like the first option, Beekeeper Studio is a free, open-source, cross-platform, SQL editor and database manager. It supports various databases such as MySQL, SQLite, SQL Server, and PostgreSQL.

I'm using Sql Server 2005 Management Studio on my client machine against Sql Server 2000 databases. For some reason, when I right-click to create a new diagram, the option isnt available.