I had become so accustomed to modifying my stored procedures from within my Visual Studio environment with 2003 that I couldn’t imagine living without this feature. The first time that I tried adding a database project in Visual Studio 2005, I was surprised to see C# managed procedures, but no place to place TSQL. After adding my stored procedure creation scripts to the project, I was stunned to learn that I couldn't execute them like I could in Visual Sutdio 2003!
It turns out that I was too quck to jump to conclusions: the TSQL Database project is present under “Other Projects” and I simply had not probed far enough. If you add a database project from there it will support the execution of your scripts allowing you to keep your database stored procedure and table scripts fully in sync and under source code control!