If anyone wants a screen shot I can send you one.

If you have ever used the interdev database project you will see some similarties. The right hand side is my solution with files in folders for each database object type. The left hand side is a server explorer, which displays the solutions database connections and a server explorer which combines features of enterprise manager, computer management and the query analyser object browser.

One other point to note is that the ide identifies any SQL block, outlines it and allows you to right click on it and design it, which then opens a query designer window.

Still no autocomplete, which would be very good given the deferred compilation of SQL 7 onwards.

This is the bain of my life having to fully test each route through an SP.

On the different language point. You will write the SP in C# or vb.net of cobol.net etc and it will run as per any .net language using the Common Language Runtime, which is common to all .net languages. If you read the transcript of Bill Gates keynote at teched 2001 he displays a demo of this by going to edit an SP and the language is C#. This is for Yukon which will have more and more support for the .net common runtime language.