|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Debugging Stored ProceduresHello,
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 -- I believe you need a certain edition of VS, possibly Professional.
-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "John Nolan" <x**@notmyaddy.com> wrote in message news:uwEKloBBHHA.4024@TK2MSFTNGP04.phx.gbl... > 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: Does the Developer edition of SQL Server 2005 come with a VS> > > I believe you need a certain edition of VS, possibly Professional. > > Hmm this is what I feared... how frustrating. > Thanks Tibor! > > John that includes the Database template? I don't want to buy VS out right as its not my development platform. -- > Does the Developer edition of SQL Server 2005 come with a VS I'm pretty certain that it doesn't. The only project types you get from the SQL Server installation > that includes the Database template? 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... -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "John Nolan" <x**@notmyaddy.com> wrote in message news:%23F1NOuKBHHA.3604@TK2MSFTNGP04.phx.gbl... > John Nolan wrote: > >> 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 > > 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:
> > Does the Developer edition of SQL Server 2005 come with a VS Just to confirm that I've installed SQL Server 2005 > > that includes the Database template? > > 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... 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. --  |
|||||||||||||||||||||||
Other interesting topics