Debugging Stored Procedures

Hello,
I've recently upgraded to SQL2005 standard edition and
I'm struggling to find how to debug stored procedures.
I fire up the accompanying Visual Studio and goog-ahem
MSN search suggests that I need to start up a Database
Project. This is missing in my VS. What do I need to do to
get this template? Or is there another mechanism similar to
SQL2k's debug functionality?
Thanks,
John
Tibor Karaszi wrote:

> I believe you need a certain edition of VS, possibly Professional.
Hmm this is what I feared... how frustrating.
Thanks Tibor!
John
|||John Nolan wrote:

> Tibor Karaszi wrote:
>
> Hmm this is what I feared... how frustrating.
> Thanks Tibor!
> John
Does the Developer edition of SQL Server 2005 come with a VS
that includes the Database template?
I don't want to buy VS out right as its not my development
platform.

|||Tibor Karaszi wrote:

> I'm pretty certain that it doesn't. The only project types you get
> from the SQL Server installation are "Business Intelligence", things
> like Reporting Services, SSIS and Analysis Server. I can't say 100%
> as I do have "real" VS installed, but, again, I'm pretty certain of
> it...
Just to confirm that I've installed SQL Server 2005
Developer Edition and the Visual studio that comes with it
does not include the Database template.
It seems that in their wisdom Microsoft have deemed that
debugging database stored procedures out of the scope of
database developer.