Hi,
In the past CTP releases of SQL Server 2005 and beta releases of Visual Studio 2005, it was always essential to install both products in the right order: First the client side tools of SQL Server, then the Visual Studio 2005 beta. If you did it wrong, you didn't get the templates to create and deploy .NET stored procedures, functions, user defined types and aggregates from within VS2005. Last week, I tested this on the final version of both products and... good news: the order doesn't matter anymore: first installing Visual Studio, then SQL Server 2005, and everything I needed was there... a small but soemtimes important detail, because reinstalling VS2005 is something you don't do for the sheer fun of it :-)
Nico