Re: Debugging in VS.NET

From: Jim Young (thorium48_at_hotmail.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 08:35:34 -0700

By any chance did you install XP Service Pack 2 on your machine?

http://support.microsoft.com/?id=839280

"Mike" <Mike@discussions.microsoft.com> wrote in message
news:8BBC54B3-45A7-45C7-AFC7-B051B96203ED@microsoft.com...
> After clicking "Run Stored Procedure" the IDE starts debugging, but almost
> immediately throws the following error:
>
> "Cannot debug stored procedures because the SQL Server database is not
setup
> correctly or user does not have permission to execute master.sp_sdidebug.
Run
> SQL Server setup or contact database administrator."
>
> If anyone has any ideas I would really appreciate them. If not I'm just
> going to have to get the developers edition and pray that it works.
>
> "Jim Young" wrote:
>
> > Sorry, I only saw the short reply you made, not the original post.
> >
> > All I can say is that I'm able to debug sprocs in VS.Net by stepping
into
> > the stored procedure from the Database menu. I can't find your original
> > post. What kind of problem are you having again?
> >
> > Jim
> >
> > "Mike" <Mike@discussions.microsoft.com> wrote in message
> > news:9363461F-EE37-44D6-A346-93B2DA35894A@microsoft.com...
> > > In my post I stated that i was debugging stored procedures that I
created
> > in
> > > Visual Studio using the server explorer. What additional information
do
> > you
> > > need?
> > >
> > > "Jim Young" wrote:
> > >
> > > > Come on! You've got to provide more information about your problem
then
> > > > that.
> > > >
> > > > Debugging what?
> > > >
> > > > "Mike" <Mike@discussions.microsoft.com> wrote in message
> > > > news:5635E9E3-8009-4C6D-86DF-AFF2C3067128@microsoft.com...
> > > > > Any ideas?
> > > >
> > > >
> > > >
> >
> >
> >

Relevant Pages

  • Re: Unable to view system stored procedures from .NET IDE and unable to debug SQL
    ... But what is the reason for the debug problem I mentioned below? ... try to step into a stored procedure in the Northwind database, ... Run SQL server setup or contact database ... I can't see any system stored procedures in master. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Identical database w/ identical stored procedures?
    ... > creating the maintence nightmare of updating the same stored procedure ... First of all, put your source code, tables, stored procedures and all ... This can be achieved with a help table in the database. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Does nesting stored procedures make sense to increase performance?
    ... Reducing client or middle-tier round trips to the database is a good idea in that it will reduce network traffic. ... In SQL Server 2000, because recompiles of query plans are done on a per-procedure basis, it's helpful some execute one SQL statement per procedure as well. ... If you're going to combine many calls into a single call, you'll need to add robust error handling to the "driver" procedure so as not to call procedures 2,3, and 4 if procedure 1 fails, etc. You'd need to replicate your existing client/middle-tier code's concept of success/failure results quit the batch of procedures on a failure and the return the results/return code that the client/middle-tier sees in the original. ... I've recently became aware of nesting stored procedures in SQL Server. ...
    (microsoft.public.sqlserver.programming)
  • Re: Query Analyzer Connect Option
    ... the database, but the users only have SELECT access. ... through stored procedures. ... As Mary pointed out, giving users full access to the database, and ... Books Online for SQL Server SP3 at ...
    (microsoft.public.sqlserver.tools)
  • RE: Cannot break at stored procedures from VC.NET 2003
    ... How do you debug the stored procedures in Visual Studio .NET? ... Debug Stored Procedures in Visual Studio .NET ... And which database do you work on, is it SQL Server 2000 SP3? ...
    (microsoft.public.vsnet.debugging)