SQuiL is a generic database browser for SQL Server: You can open any database and browse around without having to write SQL. It aims in the niche between SQL-centric database tools and apps written for a specific database schema.
Note that this product is in its very early development. Also, for SQuiL to work properly, your schema will have to make use of foreign keys as this is the way the relationships between tables are inferred.